Forum Discussion

sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
2 years ago
Solved

DAX flag the first occurrence

Hi, I have below data, I would like to create a calculated column (Rank) to flag only one record with 1 for a supplier that have multiple lines with the same date. for example, supplier 12345 has 9...
Need Help
  • tharunkumarRTK's avatar
    tharunkumarRTK
    2 years ago

    Hi sabd80 

    You can achieve this by creating an index column, Hope the below pattern fullfuils your requirement

    P.S. calculated columns can degrade your report performance. 

     

    If my answer fulfills your requirement then please mark my post as solution.

     

    Thanks

    Tharun

tharunkumarRTK's avatar
tharunkumarRTK
Icon for Super User rankSuper User
2 years ago

Hi sabd80 

You can achieve this by creating an index column, Hope the below pattern fullfuils your requirement

P.S. calculated columns can degrade your report performance. 

 

If my answer fulfills your requirement then please mark my post as solution.

 

Thanks

Tharun