Forum Discussion
Helper IIRename people based on unique ID
MylèneB try this column
Full_Name = Names[First_Name] & " " & Names[Last_Name] ) New Full Name = VAR __rank = RANKX ( FILTER ( ALL ( Names ) , Names[full_Name] = EARLIER ( Names[full_Name] ) ), Names[ID], , ASC, Dense ) RETURN IF ( __rank = 1, Names[full_Name], Names[full_Name] & __rank )Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡
Super UserMylèneB try this column
Full_Name = Names[First_Name] & " " & Names[Last_Name] )
New Full Name =
VAR __rank = RANKX ( FILTER ( ALL ( Names ) , Names[full_Name] = EARLIER ( Names[full_Name] ) ), Names[ID], , ASC, Dense )
RETURN
IF ( __rank = 1, Names[full_Name], Names[full_Name] & __rank )
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts 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.⚡
Helper IIHello again! Is there a way to add this column in power bi query? It's working well when I do a calculated measure, but I would like to do it directly in query to use this column after with something else, is that possible?