Hello,
I'm using power query to compile multiple spreadsheets. I have added a custom column which I need to have an If/else statement.
If my SITE column contains East and in the same row the NUMBER column contain 1 then enter "East1" This part is working but I have more data to check, else if SITE contain West and NUMBER contains 1 then enter WEST1.
This is just sample data, I have about 20 if's to compile. How to I make this work?
Thanks,
Bdenn
I'm using power query to compile multiple spreadsheets. I have added a custom column which I need to have an If/else statement.
If my SITE column contains East and in the same row the NUMBER column contain 1 then enter "East1" This part is working but I have more data to check, else if SITE contain West and NUMBER contains 1 then enter WEST1.
This is just sample data, I have about 20 if's to compile. How to I make this work?
Thanks,
Bdenn
Power Query:
if Text.Contains([SITE],"East")
and
Text.Contains([NUMBER],"1") = true then "East1"
else
if Text.Contains([SITE],"West")
and
Text.Contains([NUMBER],"1") = true then "West1"
else
"NO"