Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

if condition in powerquery

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 po...
  • KT_Bsmart2gethe's avatar
    3 years ago

    Hi Anonymous ,

     

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

    then [Qty]*2

    else [Qty]/2

     

    Regards

    KT