Forum Discussion
OR statements
Hello ola7mat,
Using https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/ as a guide:
(input) => let values = { { "Blue", true }, { "Red", true }, { input, false } }, Result = List.First ( List.Select ( values, each _{ 0 } = input ) ) { 1 } in ResultAdd Custom Column:
= fnSwitch ( [Colours] )
Yields the following result:
The function allows you not to have to rewrite the many formula's. Define it once and call it as necessary. Possibly share some more details about the data and your desired output(s).
Hello ola7mat,
Using https://www.powerquery.training/portfolio/replicate-power-pivots-switch-function/ as a guide:
(input) =>
let
values = {
{ "Blue", true },
{ "Red", true },
{ input, false }
},
Result = List.First ( List.Select ( values, each _{ 0 } = input ) ) { 1 }
in
ResultAdd Custom Column:
= fnSwitch ( [Colours] )
Yields the following result:
Thanks for this Chris and JoHo . I am after the correct way to write this in power query though.
Chris the solution does work however I have a number of formulas where i use this and so wont create lists for each one.
Do you know what the power query version of what JoHO wrote?
IF(Table[Colour] IN {"Red", "Blue"}, TRUE(), FALSE())
The function allows you not to have to rewrite the many formula's. Define it once and call it as necessary. Possibly share some more details about the data and your desired output(s).
thanks for this, have finally got my head round the swtich function very useful.
appreciate the help very much!
