if else condition

Hi analystmatt22 ,

Measures and calculated columns are based on DAX which means they can't be created in Power Query. In Power Query, we often use M language.

Try to use group by.

The all rows column is to restore previous rows later.

Add a custom colulmn.

If you also want to match the custom column created in deliveries table to matches table. You can merge as follows.

Expand the column you want.

Merge queries overview - Power Query | Microsoft Learn

How to GROUP BY or summarize rows - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.