Forum Discussion
If Value is Less than another value
Hi Anonymous ,
We can create three measures to meet your requirement.
1. Create actual date and target date measures.
Actual date = CALCULATE(MAX('Table'[value]),'Table'[Target vs Actual]="Actual")Target date = CALCULATE(MAX('Table'[value]),'Table'[Target vs Actual]="Target")2. Then we can create an icon measure.
Measure = IF([Actual date]>[Target date],1,0)If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi Anonymous ,
We can create three measures to meet your requirement.
1. Create actual date and target date measures.
Actual date = CALCULATE(MAX('Table'[value]),'Table'[Target vs Actual]="Actual")
Target date = CALCULATE(MAX('Table'[value]),'Table'[Target vs Actual]="Target")
2. Then we can create an icon measure.
Measure = IF([Actual date]>[Target date],1,0)
If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
By the way - this WORKED PERFECT, thanks so much! (Also I wish I had asked this question sooner)