Forum Discussion

blytonpereira's avatar
blytonpereira
Helper II
7 years ago
Solved

Appending a created table + IF statement in PowerQuery

Hi I need to write an IF statement for one column vs a single value. The Key value will alwyas be only one value.   Key Value 12   Column 1   Column 2 X                    IF (Key Value) < a th...
Need Help
  • ImkeF's avatar
    ImkeF
    7 years ago

    No need to transform your single value to a column, instead just reference it directly like so:

     

    Table.AddColumn(#"Fin MonthOffset", "Custom", each if #"Vlookup to Fin MonthNo"=[Fin MonthNo] then "xx" else "xy")
ImkeF's avatar
ImkeF
Community Champion
7 years ago

No need to transform your single value to a column, instead just reference it directly like so:

 

Table.AddColumn(#"Fin MonthOffset", "Custom", each if #"Vlookup to Fin MonthNo"=[Fin MonthNo] then "xx" else "xy")