Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
@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"
)
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
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
User | Count |
---|---|
141 | |
70 | |
70 | |
53 | |
53 |
User | Count |
---|---|
208 | |
95 | |
64 | |
61 | |
57 |