Forum Discussion
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 example) with a number only if they have the same ID
Thanks a lot!!
Hi,
Create the new column in your table and use the Rankx function :
Rank = RANKX(Sheet149, Sheet149[ID Box], , ASC , Dense)
2 Replies
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.
Hi,
Create the new column in your table and use the Rankx function :
Rank = RANKX(Sheet149, Sheet149[ID Box], , ASC , Dense)
