Forum Discussion
Use SWITCH in PowerQuery Transform steps
I would like to use a column with a SWITCH formula in PowerQuery to identify bad values and replace them. In this example I have only one case, "#N/A", and the word "CHECK" to flag these for now. The...
Hi Anonymous ,
You cannot use SWITCH in Power Query. Instead use the below formula:each if [act_pid] = "#N/A" then "CHECK" else ""Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
Hi Anonymous ,
You cannot use SWITCH in Power Query. Instead use the below formula:
each if [act_pid] = "#N/A" then "CHECK" else ""Give a Thumbs Up if this post helped you in any way and Mark This Post as Solution if it solved your query !!!
I'm not thrilled that I will have to write some elaborate nested if statement, but I really appreciate your (quick!) response. Thank you!