Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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! | |
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
117 | |
84 | |
49 | |
38 | |
28 |
User | Count |
---|---|
188 | |
76 | |
73 | |
54 | |
42 |