Forum Discussion
Solved
Comparing Dates
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 t...
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.
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