Forum Discussion

CJ_96601's avatar
CJ_96601
Helper V
6 years ago

DAX Help

Hi, please refer to below tables:   Table 1 shows employee No (EmpNo) Table 2 shows employee details with performance rating and year   Table 1 and table 2 relationship is by EmpNo   Filtered ...
Need Help
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
6 years ago

CJ_96601 

You may refer to the measure below.

 

Measure =
MAXX (
    FILTER (
        Table2,
        Table2[Year]
            = SELECTEDVALUE ( 'Calendar'[Year] ) - 1
    ),
    Table2[Performance]
) & ""

 

CJ_96601's avatar
CJ_96601
Helper V
6 years ago

Thanks...but it is not working...