Forum Discussion
Adding custom column with many complex conditions
Hi,
I could like to add a custom column with many conditions (hundreds) and filling out the dialog is not very user friendly:
is there a better way how to tacle this? Thanks!
I've seen the described possibility, but ist is too cumbersome. I will edit the statement in text editor and paste it into the window. This should work - thanks anyway!
2 Replies
PowwerBI Well, there is a conditional column dialog that you can use. In Power Query Editor, the Add Column tab and then Conditional Column in the General area. Basically going to be a bunch of if then else statements but the Conditional Column interface is perhaps friendlier. M does not have a true SWITCH statement so perhaps DAX might be a different way to go?
I've seen the described possibility, but ist is too cumbersome. I will edit the statement in text editor and paste it into the window. This should work - thanks anyway!
