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.
Customer | Price |
Costco USA | 754 |
Walmart MX | 365 |
Kenny's USA | 956 |
Freddy's | 457 |
From the table above I need to replace the whole cell value for only those that contain the word "USA" to "Offboarded" so I can end up with a table like this
Customer | Price |
Offboarded | 754 |
Walmart MX | 365 |
Offboarded | 956 |
Freddy's | 457 |
I have looked into DAX's "Replace" and "substitute" but cannot make it work for this particular scenario where I believe the usage of *wildcards* may be required.
Any suggestions are truly appreciated.
Solved! Go to Solution.
@Anonymous , Try a new column like
if(search("USA",[Customer],,0) >0, "Offboarded",[Customer])
User | Count |
---|---|
136 | |
70 | |
69 | |
54 | |
52 |
User | Count |
---|---|
207 | |
94 | |
64 | |
61 | |
57 |