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