Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Qty | ReqUom | Base Uom | Match |
25 | lb | lb | TRUE |
30 | kg | kg | TRUE |
40 | lb | kg | FALSE |
50 | kg | lb | FALSE |
Am trying to write a formular in powerquery because it is a table i append in power query so i need the calculation in power query.
Solved! Go to Solution.
Hi @Anonymous ,
if [UomMatch] = false and [Base]= kg
then [Qty]*2
else [Qty]/2
Regards
KT
Hi @Anonymous ,
if [UomMatch] = false and [Base]= kg
then [Qty]*2
else [Qty]/2
Regards
KT