Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a colum with different values but i want to make a new calculated column that checks the values in the other column
i believe the switch function would work here but im not sure how to use it.
I need a few checks in the formula.
He needs to check a couple of things.
1. IF value in column 'AP gebied naam' contains 'VB_' then "Vraagbundeling"
else
2. IF value in column 'AP gebied naam' contains '-E0' then "Nieuwbouw"
else
3. "Hoofdproject"
Hopefully someone can help me out here
Solved! Go to Solution.
General Switch Formula would be:
SWITCH(['AP gebied naam'];
"VB_";"Vraagbundeling"
"-E0";Niewbouw;
"Hoofdproject")
There is also a CONTAINS formula. But I have never used it before. So if you can give the formula the whole name of the phrase to check this should work.
Just for perfection including contains:
=SWITCH(TRUE();
NOT(ISERROR(SEARCH("VB_";['AP gebied naam'])));"Vraagbundeling";
NOT(ISERROR(SEARCH("-E0";['AP gebied naam'])));"Nieuwbouw";
"Hoofproject")
General Switch Formula would be:
SWITCH(['AP gebied naam'];
"VB_";"Vraagbundeling"
"-E0";Niewbouw;
"Hoofdproject")
There is also a CONTAINS formula. But I have never used it before. So if you can give the formula the whole name of the phrase to check this should work.
@FloriankxCONTAINS will not help here, but your switch statement is correct and it's exactly what @RvdHeijden needs here. CONTAINS checks to see if a certain column has a certain value anywhere in the entire column. So it's not particularly useful on a row-by-row case like this one.
Proud to be a Super User!
Hello,
it should. Please try it and let me know.
If more than one LogicalTest is true I think switch stops after the first true one.
Best regards.
No, it doesn't check substrings. The value has to literally be "VB_" or "-E0". If it's something like "VB_-E0" that won't count.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
145 | |
108 | |
107 | |
89 | |
61 |