Forum Discussion

jonclay's avatar
jonclay
Helper 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])

     

amitchandak's avatar
amitchandak
Super User
4 years ago

jonclay , a New column in Dax

 

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

 

jonclay's avatar
jonclay
Helper IV
4 years ago

Hi there Amit,

Many thanks for your quick reply. I've tried this and I get an error saying "Token Literal expected" on the [Date] after the &&. Do you know why this might be?

Many thanks
Jon

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    jonclay , Can you share what you created.  Suggested one seem correct to me

    • jonclay's avatar
      jonclay
      Helper 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