How to conditional merge tables in Power Query
In today’s video i will show you one technique for conditional merging tables in Power Query.
Watch the tutorial:

Was this helpful?
Learn how to grow your business with your data and Power BI
In today’s video i will show you one technique for conditional merging tables in Power Query.
Thanks Ruth! This works for smaller datasets but I have a 6k records lookup table and a 8Million transaction table. The query has been running for more than 10 hours
Power Query is not great for bigger data. Do it at the source if possible.