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"...
Need Help
Tutorial Requests
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

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

Hello @amitchandak

How are you ?

Have you an other idea please ?

Thanks

  • v-easonf-msft's avatar
    v-easonf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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