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 IIIYes, I have user_type as Suspect, Witness Victim. And I want to filter this out by Victim only.
SpartaBI
Community Champion
Community Championhello_MTC can you maybe share a sample data so I could copy it to Power BI and send back the result?
- hello_MTC
how to share
- SpartaBI
hello_MTC either you share a sample PBIX (through a link from onedrive/gdrive/dropbox/etc or just create a sample data in excel and copy paste the table to the message here.
- hello_MTC
Never mind! I solved it!
ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)