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

Hi Amit

Thank you. Please see the image below (using the exact column names rather than date etc):


Many thanks
Jon

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

    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.