Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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.

 

 

 

 

 

"Date Table"
Column Comparison
hierachy

1 Reply

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago
    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.