Forum Discussion

lkshck's avatar
lkshck
Helper III
3 years ago
Solved

Combining several IF/Else Statements

Hey, I'm having a table of Azure Cost Management which contains a lot of Cost data and I would like to introduce a Column called Business Service. Currently I made a new Column for every Business se...
Need Help
  • lkshck's avatar
    lkshck
    3 years ago

    Got it in the first step running with this one:

    Business Service = 
SWITCH(
  TRUE(),
  CONTAINSSTRINGEXACT('Usage details'[JsonTags.area], "dl-big-data")=TRUE(), "Data Engineering",
  CONTAINSSTRING('Usage details'[ReservationName], "Big-Data")=TRUE(), "Data Engineering",
  CONTAINSSTRING('Usage details'[ReservationName], "ADX")=TRUE(), "Data Engineering",
  "Unallocated"
)

     

lkshck's avatar
lkshck
Helper III
3 years ago

Looks like this doesn't work.

 

lkshck's avatar
lkshck
Helper III
3 years ago

Got it in the first step running with this one:

Business Service = 
SWITCH(
  TRUE(),
  CONTAINSSTRINGEXACT('Usage details'[JsonTags.area], "dl-big-data")=TRUE(), "Data Engineering",
  CONTAINSSTRING('Usage details'[ReservationName], "Big-Data")=TRUE(), "Data Engineering",
  CONTAINSSTRING('Usage details'[ReservationName], "ADX")=TRUE(), "Data Engineering",
  "Unallocated"
)