Forum Discussion

jonclay's avatar
jonclay
Icon for Helper IV rankHelper IV
4 years ago
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...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    jonclay , a New column in Dax

     

    Countx(filter( Table, [donation] =earlier([donation]) && [Date] <= earlier([Date]) ), [Date])

     

jonclay's avatar
jonclay
Icon for Helper IV rankHelper IV
4 years ago

I've just discovered that this doesn't work in Direct Query Mode (which I was in). I changed the Mode and this now works. Thank you!