Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Sylvine_Wyz
Helper IV
Helper IV

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

4 REPLIES 4
amitchandak
Super User
Super User

@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"
)

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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

Hello @amitchandak

How are you ?

Have you an other idea please ?

Thanks

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.