Forum Discussion

Sylvine_Wyz's avatar
Sylvine_Wyz
Icon for Helper IV rankHelper IV
5 years ago

IF dax (new column)

Hello Everybody, 

 

i would like to create a new column with the formule IF to replace data.
I want to create a formule with several IF including 2 IF to say if the column "..." contains "montage" then "Montages"

 

Below that i want to say :

IF('wyz_reporting bi_wyzbiz_recap'[type]="tyre","Pneus",IF('wyz_reporting bi_wyzbiz_recap'[type]="management fee","Management fee",IF('wyz_reporting bi_wyzbiz_recap'[type]="assembly","Montages",IF('wyz_reporting bi_wyzbiz_recap'[reference] CONTAINS "montage","Montages" ..... 

Can you help me please ?

 

Thanks in advance

 

Have a nice day

Need Help
Tutorial Requests

4 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Sylvine_Wyz , Not very clear . See if this can help Try like

    Switch( True()
    'wyz_reporting bi_wyzbiz_recap'[type]="tyre","Pneus",
    'wyz_reporting bi_wyzbiz_recap'[type]="management fee","Management fee",
    'wyz_reporting bi_wyzbiz_recap'[type]="assembly","Montages",
    Search("montage",'wyz_reporting bi_wyzbiz_recap'[reference],,0) > 0 "Montages"
    )

    • Sylvine_Wyz's avatar
      Sylvine_Wyz
      Icon for Helper IV rankHelper IV
      5 years ago

      Merci pour ton aide. 

      Mais la formule ne fonctionne pas. 

      En fait, j'aimerai dire : 

      Si dans la table wyzbizrecap et dans la colonne Type = tyre alors Pneus, 

      Si dans la table wyzbizrecap et dans la colonne Type = management fee alors Management Fee,

      Si dans la table wyzbizrecap et dans la colonne Type = assembly alors Montages

      Si dans la table wyzbizrecap et la colonne Reference contient Demontage/Montage alors Autres prestas, 

      Si dans la table wyzbizrecap et la colonne Reference contient Montage alors Montages