Forum Discussion
List.Max on Table.Select with Field Filter
I've got a Calendar query and a "Campaign" query and I'm trying to bring in the Campaign Start Date into my Calendar query. I'm trying to add a custom column: Table.AddColumn(#"Changed Date c...
I would use the Merge GUI function (Join) to Join your calendar table to your campaign start table, and then fill down the nulls, like:
Table.Join(Calendar, {"Date"}, #"Campaign Start", {"Starting_Date"}, JoinKind.LeftOuter)
Now you can just use the FillDown button in the GUI to replace the nulls in the Campaign Start column.
--Nate
Anonymous
You cannot refer to the column in other tables in power query. You need do some transformation(merge,append,etc) to combine the date column into the Campaign query.
Paul Zheng _ Community Support Team