Adding custom column with many complex conditions

[PowwerBI]

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!

[Greg_Deckler]

@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?

[PowwerBI · Accepted solution]

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!