Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table that shows the budget and booked hours of our employees.
Now I want to filter the employees that stopped working in our company before the selected date.
In the demension I made the following expression:
=if( ALT(EmploymentEnddate,0)=0, EmployeeFullName, if(Min(Year)< Year(EmploymentEnddate), EmployeeFullName))
If I test it in a measure it gives me the correct values but in the demension it gives me an invalid demension.
How can I solve this problem?
Hi may be this
aggr(
if( ALT(EmploymentEnddate,0)=0, EmployeeFullName, if(Min(Year)< Year(EmploymentEnddate), EmployeeFullName))
, EmployeeFullName,EmploymentEnddate)
Hi may be this
aggr(
if( ALT(EmploymentEnddate,0)=0, EmployeeFullName, if(Min(Year)< Year(EmploymentEnddate), EmployeeFullName))
, EmployeeFullName,EmploymentEnddate)
Thanks @brunobertels that works!