Forum Discussion
Solved
Column Values based on Rank and Date
Hi, I have the table below which uses RANKX to show the occurrence of each employee for each day. RANKX ( FILTER ( 'TABLE', 'TABLE'[Employee] = EARLIER ( 'TABLE'[Employee] ) && 'TABLE'[...
Hi,
Try this calculated column formula
Status = if(Data[Employee rows]=2,if(Data[Rank]=1,BLANK(),CONCATENATEX(filter(Data,Data[Employee]=EARLIER(Data[Employee])&&Data[Date]=EARLIER(Data[Date])),Data[Code],"+")),Data[Code])Hope this helps.
I did try this before and wasn't get the same result but this works now.
Thank you for all your help Ashish.
You are welcome.