If logic help

[mahitham]

Hi Experts,

Can any one please help me on below requirement.

I have a table with all the dimensions

In Employee Name dimension I have to show only Max(Year) employees. I have tried like below

=if(Year =Max(Year), [Employee Name]) but getting invalid dimension in the table.

Please help me on this.

Thanks in advance.

[ChennaiahNallani · Accepted solution]

Variable

MaxYear = max(Year)

Exp..

=if(Year =$(MaxYear), [Employee Name])