Forum Discussion

rvnaresh's avatar
rvnaresh
Microsoft Employee
3 years ago

Try to use OR function with if and text contains

Hi, I want to categorize the datacenter to a region like the table below and use it in one of my reports.    Datacenter Location ABC01 Europe ABC02 Europe ACB01 Europe ACB02 Eur...
Need Help
Show and Tell
Papermain's avatar
Papermain
Frequent Visitor
3 years ago

Hello,

 

Please add the following code in a custom column:

 

let 
StartString = Text.Upper(Text.Start([Column1],2))
in 
if StartString = "AB" or StartString =  "AC" then "Europe"

else if StartString = "BA" or StartString = "BD" then "Americas"

else if StartString = "CA" or StartString = "CD" then "APAC"

else "Uncategorized"