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.