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
Icon for Community Champion rankCommunity Champion
4 years ago

hello_MTC can you maybe share a sample data so I could copy it to Power BI and send back the result?

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)