Forum Discussion
Helper IMerge queries with WHERE condition
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!
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.
1 Reply
- AlexisOlson
Super User
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.