Show values from 2 different date columns

[Emanuel]

Hi all,

I need to merge these 2 graphs in 1. 

 

Each of them have a different date column: submit date and last completed date. The measures are:

count_of_PBI = COUNT(Report[Problem ID*+])

count_of_lastCompleted = COUNT(Report[Last Completed Date])

The outcome should be :

Thank you in advance for the help.

[vivran22 · Accepted solution]

Hello @Emanuel ,

Based on your description, you need to show two different date field on one axis. For this, you can take help of a calendar table

https://www.vivran.in/post/power-bi-time-intelligence-calendar-table

and the connect it with your data table on both the dates:

Then modify your measures with USERELATIONSHIPS:

Count_of_lastCompleted =
   CALCULATE(

      COUNT(Report[Last Completed Date]),

             USERELATIONSHIP(Report[Last Completed Date]), ftCalendar[Date])
)

Please follow the artilce for more details:

https://www.vivran.in/post/multiple-dates-on-the-same-axis-dax-userelationship

Cheers!
Vivek

Blog: vivran.in/my-blog
Connect on LinkedIn
Follow on Twitter