Comparing Dates

[jen8080]

Hello,

I am new to Power BI and I am trying to compare two 'milestone actual dates' for one 'ID'. 

I set it up in a matrix and thought it would be a simple quick measure, and haven't found one that would work.

I have to blurr out some items, but hopefully you get the idea.

this is how I currently have the matrix setup:

This is how I need to see the data side by side and then just a column to say if the first date occured before the 2nd , with a yes, no answer. If the first date is blank it can just show 'N/A' and if the 2nd date is blank but there is a date in the first column it should read 'yes'

Thanks for any help,

[AlexRao]

Hello,

  I too have a similar situation, but I want to keep the dates in mm/dd/yyyy format and compare, that way it will be easy for the team to fix the data, how do I do that? Thank you for any tips

[jen8080]

Hello @amitchandak 

I took out the senstive data and just filled in with a small sample set. I need to be able to look at the 'ID' and compare the 'Milestone Name columns of  'Live' and 'In Date'.

Then compare the 2 milestones acutal dates to each other, then confirm if the 'Live' Acutal date was before the 'In Date'. actual date.

If the 'Live' acutal date was before the 'In Date' actuual date have it bring back 'Yes' and if we was not met have it bring back 'No'

Here is a sample table:

[V-pazhen-msft · Accepted solution]

@jen8080 
Try create 2 measures to get actually date for each id.

Live measure = Calculated(MAX([Acutal Date]),Filter(allselected(Table),[Milesstone Name] = "Live" && [ID]=MAX[ID]))

In Date measure = Calculated(MAX([Acutal Date]),Filter(allselected(Table),[Milesstone Name] = "In Date" && [ID]=MAX[ID]))

Then You can put the ID column and the 2 measures a table visual. To compare the measures, another measure should be added to he visual, something like:

Compare measure = If([Live measure]<[In Date measure], "Yes", "No")

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@jen8080 , The information you have provided is not making the problem clear to me. Can you please explain with an example.
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Appreciate your Kudos.