Forum Discussion

Helper V

8 years ago

Solved

Conditional formatting on calculated field

I would like to apply conditional formatting on my calculated field. I use the following DAX: Jubileum = VAR Months = DATEDIFF([Medewerker in dienst];TODAY();MONTH) VAR Years = ROUNDDOWN(Months/...

8 years ago

The formula below will help

Measure 1 =
IF (
    MOD ( MAX ( [Years] ) + 1, 5 )
        = 0
        && (
            MAX ( [Months] ) = 10
                || MAX ( [Months] ) = 11
        ),
    1,
    0
)

Additionally, you could refer to my pbix.

Best Regards

Maggie

v-juanli-msft
8 years ago
Hi RemiAnthonise

Te icon is different because you create "Measure jubileum" as a calculated column, you need create a new measure and then put this formula.

Best Regards

Maggie