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.
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.