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
PhilipTreacy's avatar
PhilipTreacy
Super User
5 years ago

Hi balar2007 

To look for the string EBOB in [Formula] modify the line to this

CONTAINSSTRING( [Formula], "EBOB" ), "MOGAS"

Regards

Phil