Convert Spotfire Condition

[LD]

Please, How I can convert following Spotfire condition in Power Bi?

case  when ([POSOWNER]="PACKAGING") or ([POSOWNER]="WAREHOUSE") then "P&WH"
 when [POSOWNER]="ASEPTIC" then "ASEPTIC"
 when [POSOWNER]="QC" then "QC"
 when [POSOWNER]="BACTERIAL PRIMARY" then "BACTERIAL PRIMARY"
 when [POSOWNER]="BACTERIAL GLYCO" then "BACTERIAL PRIMARY"
 when [POSOWNER]="BACTERIAL OMV" then "BACTERIAL PRIMARY"
 when [POSOWNER]="PRODUCT RELEASE" then "PRODUCT RELEASE"
else "OTHER" end

Thank you

[az38 · Accepted solution]

Hi @LD 

try SWITCH()

Column = SWITCH([POSOWNER],
"PACKAGING", "P&WH",
"WAREHOUSE", "P&WH",
"ASEPTIC","ASEPTIC",
"QC","QC",
BACTERIAL PRIMARY","BACTERIAL PRIMARY",
"BACTERIAL GLYCO", "BACTERIAL PRIMARY",
"BACTERIAL OMV" , "BACTERIAL PRIMARY",
"PRODUCT RELEASE", "PRODUCT RELEASE",
"OTHER"
)

do not hesitate to give a kudo to useful posts and mark solutions as solution

LinkedIn

[Anonymous]

You can do it in two ways

1 which is above suggested using switch and another one is nested if statements.

But as per coding point of view switch functions are better for such requirements.

Thanks
Pravin

If it resolves your problem Mark it as a solution and give Kudos.