Forum Discussion
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 [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
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
2 Replies
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
