Forum Discussion

hello_MTC's avatar
hello_MTC
Icon for Helper III rankHelper III
4 years ago
Solved

Add 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.      
Need Help
  • SpartaBI's avatar
    SpartaBI
    4 years ago

    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:

     

     





          

    Showcase Report – Contoso By SpartaBI

  • hello_MTC's avatar
    hello_MTC
    4 years ago

    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_MTC's avatar
hello_MTC
Icon for Helper III rankHelper III
4 years ago

how to share

SpartaBI's avatar
SpartaBI
Icon for Community Champion rankCommunity Champion
4 years ago

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's avatar
    hello_MTC
    Icon for Helper III rankHelper III
    4 years ago

    Never mind! I solved it!

    ID2 = RANKX(FILTER('actdb users_outcome','actdb users_outcome'[user_type]="Victim"),'actdb users_outcome'[user_id],,ASC,Dense)