Forum Discussion
Solved
Adding a sequential number based on the date
Hi everyone I'm having a problem adding a sequential number column to my Power BI report and wondered if someone could please help? Our CRM system hold various donations, each of which have multi...
jonclay , a New column in Dax
Countx(filter( Table, [donation] =earlier([donation]) && [Date] <= earlier([Date]) ), [Date])
jonclay , Can you share what you created. Suggested one seem correct to me
Hi Amit
Thank you. Please see the image below (using the exact column names rather than date etc):
Many thanks
Jon
amitchandak Ah yes, of course! However, when I try to create a new Column in the Modeling tab and then enter the DAX, it doesn't seem to recogise the 'earlier' word.