Forum Discussion
Solved
Coding a Custom Column Based on Relative Earliness of Date
Hi everyone, I've been trying to code for a custom column in the advanced editor, but I've been unable to get it right. I'm hoping that someone can help me out! My goal is to generate a "visi...
I used some of your data to scrap this up. Seems to work just fine. Understanding exactly what EARLIER() does helps here.
Visit Count = COUNTROWS(FILTER(Data, Data[ID] = EARLIER([ID]) && Data[Visit Date] <= EARLIER([Visit Date])))
I used some of your data to scrap this up. Seems to work just fine. Understanding exactly what EARLIER() does helps here.
Visit Count = COUNTROWS(FILTER(Data, Data[ID] = EARLIER([ID]) && Data[Visit Date] <= EARLIER([Visit Date])))
Thank you very much Anonymous. I'm getting exactly what I was hoping to see. I really appreciate your help!