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.
This is the logic I've been trying to figure out how to do! Thanks so much, I will play with this!