Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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