Propagate information from one table to another

[Syndicate_Admin]

Hello

I need help with a topic:

Let's say I have two tables:

1. Holiday Table:

2. Festive table:

I need you to create for me for each employee all the dates that the "Holidays Table" table has depending on the location. For example, the result would look like this:

Thanks in advance and best regards,

[v-yangliu-msft · Accepted solution]

Hi  @Syndicate_Admin ,

Here are the steps you can follow：

1. In Power Query – Home – Merge Queries -- Merge Queries as new .

Expand Table2:

2. Append Queries as new.

3. Add Conditionaal Column.

4. Remove the original column [Holiday date] and rename [Custom] to [Holiday date].

5. Result:

Best Regards,

Liu Yang

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