Custom Column if formula

[Anonymous]

Hi Experts

how would you write the following If else formula for a custom column in Power Query

Currency = if [storeid] =1 then "GBP" elseif

[storeid] = 2, then "Eur" elseif

[storeid = 3 then "IRE" elseif

[storeid] = 4 then "USD"

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can write it something as follows:

if [storeid] = 1 then "GBP"

else if [storeid] = 2, then "Eur"

else if [storeid = 3 then "IRE"

else if [storeid] = 4 then "USD"

else " "

Thanks,

Pragati

[Anonymous]

Many Thanks

[AlB]

Hi @Anonymous 
You were very close:

if [storeid] =1 then "GBP" else if
[storeid] = 2  then "Eur" else if
[storeid] = 3 then "IRE" else if
[storeid] = 4 then "USD" else null

Please accept the solution when done and consider giving a thumbs up if posts are helpful.  Contact me privately for support with any larger-scale BI needs, tutoring, etc.