Forum Discussion
Show charts with 2 dates in one table
I have 2 dates in one dataset: 'StartDate' and 'EndDate' All records will have StartDate, but not all records will have EndDate. In this case, how can I show them with 'Clustered column char...
You will use the USERELATIONSHIP function to "activate" the inactive relationship
SomeMeasure = COUNTROWS(MyTable)
Total Start Count := CALCULATE( [SomeMeasure] )
Total End Count := CALCULATE( [SomeMeasure], USERELATIONSHIP(MyTable[EndDate], Calendar[Date]))