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"
)

     

henktermaat's avatar
henktermaat
Regular Visitor
3 years ago

Hello Lkshck,

 

Maybe ‘SWITCH’ can help  you? Implemented would be as follows:

 

SWICTH(

  TRUE,

  CONTAINSSTRINGEXACT('Usage details'[JsonTags.area] = "dl-big-data", 1,

  CONTAINSSTRING('Usage details'[ReservationName] = "Big-Data", 1,

  CONTAINSSTRING('Usage details'[ReservationName] = "ADX",1,

  0

)

  • 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"
)