Forum Discussion

kevinsray's avatar
kevinsray
Helper II
6 years ago
Solved

Find Difference between Measure Values and Column Values

OK, so I am trying to get some conditional formatting happening, but it is quite difficult. We have a report which shows as follows Task        Frequency LastDone Task 1     Yearly        1/1/2018...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi kevinsray,

    You could try below measures:

    color =
IF (
    DATEDIFF ( MAX ( test[LastDone] ), TODAY (), DAY ) > MIN ( test[MaxDays] ),
    "red",
    "green"
)

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

kevinsray's avatar
kevinsray
Helper II
6 years ago

Very nice. 
However, when I tried to setup the formatting, it wouldn`t let me select color in the rules

dax's avatar
dax
Community Support
6 years ago

Hi kevinsray,

You could see I use Field Value when set conditional format, I have set color in measure. If you want to change color you could use "#50C7C7" to replace "red" or "green". You could get color code in color picker(https://htmlcolors.com/google-color-picker)

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.