Forum Discussion

LD's avatar
LD
Frequent Visitor
6 years ago
Solved

Convert Spotfire Condition

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 [...
  • az38's avatar
    az38
    6 years ago

    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

az38's avatar
az38
Icon for Community Champion rankCommunity Champion
6 years ago

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's avatar
    Anonymous
    Not applicable
    6 years ago
    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.