Forum Discussion
MCode - if & And Formula
I'm trying to create a custom column, with PowerQuery. I'm having difficulty with the MCode. How could this be re-written in PQ?
Temp Closure = if('Emergency Status'[RX]="TRUE" && 'Emergency Status'[FE]="TRUE","FE/Rx",
if('Emergency Status'[RX]="FALSE" && 'Emergency Status'[FE]="TRUE","FE",
if('Emergency Status'[RX]="TRUE" && 'Emergency Status'[FE]="FALSE","RX",
if('Emergency Status'[RX]="FALSE" && 'Emergency Status'[FE]="FALSE","Restricted Hrs."))))
Hi, jcastr02
try using if...then ...else
e.g, select the emergency status query in power query editor >> add column >> custom column >>
= if [RX] = true and [FE] = true then "FE/Rx"
else if [RX] = false and [FE] = true then "FE"
else if [RX] = true and [FE] = false then "RX"
else "Restricted Hrs."
)
1 Reply
Hi, jcastr02
try using if...then ...else
e.g, select the emergency status query in power query editor >> add column >> custom column >>
= if [RX] = true and [FE] = true then "FE/Rx"
else if [RX] = false and [FE] = true then "FE"
else if [RX] = true and [FE] = false then "RX"
else "Restricted Hrs."
)