Forum Discussion
hello_MTC
Helper III
Helper IIIAdd a new Column using IF or any other functions
Hello, I want to add a column(ID) in Power BI query editor same like I have added it in Excel using IF function. See picture below. column(user_id) should be sorted out low to high.
hello_MTC is it ok if it will be in dax? You basically need a ranking column there.
If yes, then you just want to write this calculated column:
CALC = RANKX('Table', 'Table'[user_id],,ASC,Dense)
I added a sample with differnet numbers:Never mind! I solved it!
ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)
hello_MTCHelper III
Helper IIINever mind! I solved it!
ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)
SpartaBI
Community Champion
Community Championhello_MTC Great! 🙂
Will appreciate your kudos on my messages :))
P.S. Check out my showcase report - got some high level stuff there. Sure you will find there a lot of cool ideas.
https://community.powerbi.com/t5/Data-Stories-Gallery/SpartaBI-Feat-Contoso-100K/td-p/2449543
Give it a thumbs up over there if you liked it 🙂