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.
Morning All
Im sure there is an easy way to do this.
Maybe using a switch function as that can cater for blanks?
I have a table that will have data like that in Table 1 Column 1
I want to add a new conditional column 2 which will do the following:
If it finds the String ITC then in the new conditional column it will output IT Component
If it finds the String APP then in the new conditional column it will output IT Application
Excel Mock Up
Table 1 – Current
Data Source |
APP-51059 |
APP-51026 |
APP-51037 |
APP-51040 |
ITC-92620 |
ITC-92338 |
ITC-92828 |
Table 2 – Required
Data Source | New Conditional Column |
APP-51059 | IT Application |
APP-51026 | IT Application |
APP-51037 | IT Application |
APP-51040 | IT Application |
ITC-92620 | IT Component |
ITC-92338 | IT Component |
ITC-92828 | IT Component |
Any pointers appreciated.
Jimmy
Solved! Go to Solution.
Hi @Anonymous ,
You can do this in Power Query as well with a conditional column, but if you want to add a DAX calculated column you can try this:
Conditional Column =
SWITCH(TRUE(),
CONTAINSSTRING(Source[Data Source],"APP"), "IT Application",
CONTAINSSTRING(Source[Data Source],"ITC"), "IT Component",
"Other")
You can replace "Other" with just "" if you want to show blanks on no match, and you can also expand the switch statement to search for additional strings and display a different result.
Proud to be a Super User! | |
Hi @Anonymous ,
You can do this in Power Query as well with a conditional column, but if you want to add a DAX calculated column you can try this:
Conditional Column =
SWITCH(TRUE(),
CONTAINSSTRING(Source[Data Source],"APP"), "IT Application",
CONTAINSSTRING(Source[Data Source],"ITC"), "IT Component",
"Other")
You can replace "Other" with just "" if you want to show blanks on no match, and you can also expand the switch statement to search for additional strings and display a different result.
Proud to be a Super User! | |
And here is how you would need to configure a conditional column in Power Query instead:
Hope this helps.
Proud to be a Super User! | |
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |