Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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."))))
Solved! Go to 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."
)
Proud to be a Super User!
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."
)
Proud to be a Super User!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
25 | |
12 | |
12 | |
11 | |
8 |
User | Count |
---|---|
42 | |
27 | |
14 | |
14 | |
12 |