Forum Discussion
mccollough
Helper I
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 'S...
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.
AlexisOlson
Super User
Super UserOne 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.