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

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

if the supplier has the same dates, then only in power query you can do this

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

    Ahmedx , Thanks for your solution.
    I need the other records, so I can't remove them, plus I have a huge data all these transformation will affect the performance of the report.

    • Ahmedx's avatar
      Ahmedx
      Icon for Super User rankSuper User
      2 years ago

      to do this remove the last two steps
      and then you will be able to work with the data and filter it using DAX