topic Convert Spotfire Condition in DAX Commands and Tips

Convert Spotfire Condition

LD — Wed, 05 Feb 2020 16:17:31 GMT

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

Re: Convert Spotfire Condition

az38 — Wed, 05 Feb 2020 17:47:49 GMT

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

Re: Convert Spotfire Condition

Anonymous — Wed, 05 Feb 2020 18:53:13 GMT

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.