if condition in powerquery

[Anonymous]

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.

if the match is false and the req uom is in "kg"  i want to multiply the quantity by 2 to change it to "lb"

and if the match is false and the req uom is in lb" i want to divide the quantity by 2 to change to "kg"

so the base uom is the standard unit

[Anonymous]

Thanks @KT_Bsmart2gethe it helped

[KT_Bsmart2gethe · Accepted solution]

Hi @Anonymous ,

if [UomMatch] = false and [Base]= kg

then [Qty]*2

else [Qty]/2

Regards

KT