Forum Discussion

deaconb's avatar
deaconb
Icon for Helper I rankHelper I
1 year ago

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...
Conditional Formatting
Sahir_Maharaj's avatar
Sahir_Maharaj
Icon for Super User rankSuper User
1 year ago

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
deaconb's avatar
deaconb
Icon for Helper I rankHelper I
1 year ago

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.