Merge queries with WHERE condition

[mccollough]

Hi Everyone!

I want to add a column to a table via power query with something analogous to a WHERE clause.

Here's a simplified version of what I'm trying to do:

Take the [TASK] from the 'Schedule' Table Where [INCLUDE] = 1

Add the activities into my 'Fact Table' which looks like this

To yield my 'Goal' table which should ideally look like this

Thank you SO MUCH for your continued assistance!

[AlexisOlson · Accepted solution]

One way to do this would be to add a custom column (all values = 1) to the Fact Table and then do a merge matching columns DATE, NAME, and Custom with DATE, ASIGNEE, and INCLUDE.

The other way would be to merge Fact Table with Schedule after filtering the latter for INCLUDE = 1.