Forum Discussion

balar2007's avatar
balar2007
Regular Visitor
5 years ago

SWITCH or IF

I need to transform a case statement which i have written in spotfire to Power Bi case WHEN [Formula]~="EBOB" THEN "MOGAS" WHEN [Formula]~="G01" THEN "GASOIL" WHEN [Formula]~="G50" THEN "GASOIL" ...
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

balar2007 , Switch True will help in this case

 

Switch( True() ,
, [Formula]="EBOB" , "MOGAS"
, [Formula]="G01" , "GASOIL"
, [Formula]="G50" , "GASOIL"

, [Grade]="DAOWA" , "FO"

, ([Formula]="BOB10ARGM") && ([Grade]~="M5859") , "MOGAS"
, ([Formula]="FRONTLINEICELS") && ([Grade]~="HYWAX") , "FO"

, ([Client]="MFPERNIS") && ([Formula]~="BIPEB") , "HEDGES"

, [Formula]
)

 

refer Video: https://www.youtube.com/watch?v=gelJWktlR80

balar2007's avatar
balar2007
Regular Visitor
5 years ago

Hello Amit

Quick clarification, how do i manipulate it in case if I have to use contain in the formula you gave. For example Formula contains EBOB then equal to "MOGAS".