Forum Discussion
Conditional format latest value per user
I'm working on a report which pulls together several sources of training data. One of the widgets we need is for new employees working through the training program and capturing their training events...
Hello deaconb,
Can you please try this approach:
Latest Training Week =
VAR MaxWeekPerUser =
CALCULATE(
MAX('Data'[Week of Training]),
ALLEXCEPT('Data', 'Data'[USERNAME])
)
VAR IsLatestWeek =
IF(
MAX('Data'[Week of Training]) = MaxWeekPerUser,
2, -- Indicates the latest week
1 -- Indicates all other weeks
)
RETURN
IsLatestWeek
Unfortunately this results in the same outcome for formatting as above where the expected result is the red boxes and green box being orange, but only the green box is orange.
Your measure and my original measure are basically the same. My measure is already working for assessing the latest week or not. I don't understand why it isn't being accepted as part of the conditional formatting.
