My extract has separate created and resolved date tables in the same data source. How to compare?

[Anonymous]

Hi all,

I am hoping someone can assist me with a comparison issue I'm having with data in Power BI.

My extract has both 'Created Date Time' and 'Resolved Date Time' data in the same csv, and both have date tables / hierarchies. I have created measures to calculate the count of both and that works to a point.

The issue I'm trying to understand is how to add month and year fields. I think I need a separate date table.

I would like to achieve a result similar to the graph below from Excel.

Any advice would be greatly appreciated.

[lbendlin]

I think I need a separate date table

Correct. Create an active connection to Created Date and an inactive connection to Resolved Date.  then use USERELATIONSHIP in your measures to switch the connection as needed.