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

  • 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