Forum Discussion
Solved
Running count in Dax sort by date
Greetings, How can I create a colmn in DAX for running count of IDs, sorted descending by the date. For example: ID date RUNNING COUNT 111 1/1/2023 1 222 1...
Hi,
Write this calculated column formula
Running count = CALCULATE(COUNTROWS(Data),FILTER(Data,Data[ID]=EARLIER(Data[ID])&&Data[date]>=EARLIER(Data[date])))Hope this helps.
Ashish_Mathur Thank you! This is exactly what I wanted.
You are welcome.