IF dax (new column)

[Sylvine_Wyz]

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

[amitchandak]

@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]

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

[Sylvine_Wyz]

Hello @amitchandak

How are you ?

Have you an other idea please ?

Thanks

[v-easonf-msft]

Hi, @Sylvine_Wyz 

I'm still a little confused about your description.

Can you provide more specific sample data and expected results for testing?

Best Regards,
Community Support Team _ Eason