MCode - if & And Formula

[jcastr02]

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."))))

[rubayatyasmin · Accepted solution]

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."
)