Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 2 column Birthday_Month(Includes only month of employee birthdate) and 2nd column Pmonth(includes Present month)
I need to compare both and give output The name of Employee(Firstname)
I tried using this but this is giving the number that only 1 person Have Birthday But i need Name to be printed
Count({<EmployeeID={"=(Birthday_Month=Pmonth)"}>}FirstName)
Please help
Thanks in advance
try
Dimension
=aggr(if(Birthday_Month=Pmonth,EmployeeID),EmployeeID) << uncheck include null values for this dimension
=Firstname
No its Not working
No its not working
Dimension
=aggr(if(Birthday_Month=Pmonth,EmployeeID),EmployeeID) << uncheck include null values for this dimension
Measure
=Maxstring(Firstname)
Or
Dimension
=EmployeeID
Measure
=if(Birthday_Month=Pmonth, FirstName)