Forum Discussion

EricKautz's avatar
EricKautz
Helper I
2 years ago
Solved

create column with multiple if/or

I have a column that has different asset class names (FX, InterestRate, Commodity, and Unspecified). I want to create a new column with the below if statement.   If Asset Class = "FX" then "FX" or...
Need Help
  • ryan_mayu's avatar
    ryan_mayu
    2 years ago

    EricKautz 

    if you want to use DAX, pls try this

     

    Column = if('Table'[Asset Class] in {"FX","InterestRate","Commodity"},'Table'[Asset Class], if('Table'[Asset Class]="Unspecified" && 'Table'[Trade ID]>="11111111" && 'Table'[Trade ID]<="999999999","Commodity"))
     
     
ryan_mayu's avatar
ryan_mayu
Super User
2 years ago

EricKautz 

if you want to use DAX, pls try this

 

Column = if('Table'[Asset Class] in {"FX","InterestRate","Commodity"},'Table'[Asset Class], if('Table'[Asset Class]="Unspecified" && 'Table'[Trade ID]>="11111111" && 'Table'[Trade ID]<="999999999","Commodity"))
 
 
EricKautz's avatar
EricKautz
Helper I
2 years ago

This worked as intended, thank you.

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    2 years ago

    you are welcome