Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sequentially number duplicates

I am trying to figure out how to create a calculated column to sequentially count any duplicate values.  In my case, I need to check for duplicates in the "Shipping Order" column and sequentially num...
Need Help
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Use M as suggested or use RANKX

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you, this is exactly what I was looking for, specifically the post from Anonymous.  I thought I had searched the forums for a solution but obviously not well enough.

     

    Anonymous Thank you for your reply as well.  I needed the duplicate numbers from the calculated column, not necessarily a total count of duplicates.

    Anonymous wrote:

    Hi,

     

    I think this Forum Post answers your question.

    https://community.powerbi.com/t5/Desktop/How-to-add-Row-number-over-partition-by-Customer-DAX-or-M-query/td-p/566949

     

    Best Regards,
    Vignesh M

    If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue :)