Forum Discussion

Stephy_99's avatar
Stephy_99
New Member
4 years ago
Solved

Quick help! New Column (Same ID - Same Value)

Hi everyone! I need some urgent help with this problem, I think it's a quick measure but I couldn't figure out yet. I have a columns with ID of Boxes and I need another column ("NewColumn" in the e...
Need Help
  • MahyarTF's avatar
    MahyarTF
    4 years ago

    Hi,

    Create the new column in your table and use the Rankx function :

    Rank = RANKX(Sheet149, Sheet149[ID Box], , ASC , Dense)

     

parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Stephy_99 use RANKX function, check this post  How to use RANKX in DAX (Part 1 of 3 - Calculated Columns) - RADACAD

 

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.