Create a nested table column in a table with date ranges from another table

Hi pwildmann,

I think you need to merge two tables into one by using merge queries or  function like below

Table.SelectRows( Categories , (Magic) => Text.Contains( [LandingPage] , Magic[KeyPhrase] ) ), Then you could try create a custom column by compare each row

You could refer to PowerQuery(M)agic: Conditional Joins using Table.SelectRows() for details.

Best Regards,
Zoe Zhi

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