How can I join two differents dates in the same PowerBi Table?

Question

I need to compare summarized results from a table, merging two differents dates in the same table like this in POWERBI:

And end up with a table like this:

Which is the best way to do it?

Data in text format is useful to reproduce the error. Please follow here https://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example?rq=1 — cropgen, Apr 17 '19 at 20:02

score 0 · Accepted Answer · answered Apr 18 '19 at 06:37

I could not fit this solution in single Dax table expression, let me know if you can do it:

//Create a calculated table 
Date_New = (DISTINCT(UNION(SUMMARIZE('Date', 'Date'[CreatedDate]), SUMMARIZE('Date', 'Date'[EndDate]))))

//Add 2 calculated columns to it
Created = 
VAR TotalCreated = CALCULATE(COUNT('Date'[CreatedDate]), FILTER('Date', 'Date'[CreatedDate] = 'Date_New'[CreatedDate]) )
RETURN IF(ISBLANK(TotalCreated), 0, TotalCreated) 

Ended = 
VAR TotalEnded = CALCULATE(COUNT('Date'[EndDate]), FILTER('Date', 'Date'[EndDate] = 'Date_New'[CreatedDate]) )
RETURN IF(ISBLANK(TotalEnded), 0, TotalEnded)

Result:

Mark this answer as accepted so that future visitors know which solution worked for your problem. :) — Pratik Bhavsar, Apr 24 '19 at 04:19

How can I join two differents dates in the same PowerBi Table?

1 Answers1