Show charts with 2 dates in one table

[Anonymous]

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 chart', unable to link those 2 dates into 1 date. 

I will need a 'date' for Axis, and the value will be 1) count of StartDate  2) count of EndDate.

[v-jiascu-msft]

@Anonymous

Hi,

Could you please tell me if your problem is solved? You can mark the right answer to help others if it's convenient for you.

Best Regards!
Dale

[Anonymous]

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]))