IF-Then using columns

Try this in the formula bar and replace #"Changed Type" with the name of the previous step.

= Table.ReplaceValue(#"Changed Type", each if [Inventory Status] = "Allocation" then [Allocation Pallets] else false, each [Pallets],Replacer.ReplaceValue,{"Allocation Pallets"})

To create the Allocation Pallets column in Power Query:

1. Add Conditional Column: Go to Add Column > Conditional Column.

   • Set:
     • Column Name: Allocation Pallets.
     • Condition: Inventory Status = "Allocation".
     • Output: Pallets.
     • Else: 0.

2. Formula Alternative: Use this formula if editing directly: = Table.AddColumn(Source, "Allocation Pallets", each if [Inventory Status] = "Allocation" then [Pallets] else 0)