Calculated Column with Grouping

[Anonymous]

Hi. I'm trying to create a Yes/No Column based on the evaluation on a single "training" Column; while grouping on two other columns -- ID and Year.

The End User Question would be: Did Jimmy (ID 1001) receive training in 2017; in 2018?  

TY!

Dan

[AlexisOlson · Accepted solution]

You want to remove the quarter context, but keep UserID and Year:

Results =
IF (
    CALCULATE (
        MAX ( Table1[Training] ),
        ALLEXCEPT ( Table1, Table1[UserID], Table1[Year] )
    )
        = "Yes",
    "Yes",
    "No"
)

[Anonymous]

Yep.  Nicely Done.  Thanks!