SWITH Command to Change Only One Value in a Column

Question

I have a column with over 10,000 values, of which there are about 50 distinct values.&nbsp; I want to perform a Switch command on just 1 value and leave the other 49 values the same as they current are.&nbsp; Is there a way to add a command to the Switch to where it ignores all other values and leaves them the same as they are currently listed?&nbsp; I do not want to write 49 other lines of code and new values could appear in the future once this report is deployed to service.&nbsp;&nbsp;Action Switch = &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SWITCH(TRUE(),&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;CONTAINSSTRING('Table'[Column], "SOP"), "SOP"&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)

johnt75 · Accepted Answer

You could create a new conditional column in Power Query along the lines ofif Text.Contains([Column], "SOP") then "SOP" else [Column]and then delete the original column

Forum Discussion

SWITH Command to Change Only One Value in a Column

2 Replies

Related content

SQL ALTER command

DAX command

If command

DAX command to duplicate rows

Command Timeout