Forum Discussion

EricKautz's avatar
EricKautz
Icon for Helper I rankHelper 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"))
     
     
EricKautz's avatar
EricKautz
Icon for Helper I rankHelper I
2 years ago

Could you post the actual dax formula you used.

ryan_mayu's avatar
ryan_mayu
Icon for Super User rankSuper 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
    Icon for Helper I rankHelper I
    2 years ago

    This worked as intended, thank you.

    • ryan_mayu's avatar
      ryan_mayu
      Icon for Super User rankSuper User
      2 years ago

      you are welcome