Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
1 year ago
Solved

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 Sta...
Need Help
  • rubayatyasmin's avatar
    rubayatyasmin
    1 year ago

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

rubayatyasmin's avatar
rubayatyasmin
Community Champion
1 year ago

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