Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Variable
MaxYear = max(Year)
Exp..
=if(Year =$(MaxYear), [Employee Name])
Variable
MaxYear = max(Year)
Exp..
=if(Year =$(MaxYear), [Employee Name])