Forum Discussion
Table Nested Joint - where clause
Hello I'm builing up a summary table of sales targets and past year sales. I would like to add a column to my table containing sales of a pre-set year (ie 2015). In the following formula, I...
Hi,
Share a dataset and show the expected result.
Table.NestedJoin(#"Valeur remplacée",{"ID_Target"},Targets_Data_Year,{"ID_Target"},"Targets_Data_Year",JoinKind.LeftOuter)
= Table.ExpandTableColumn(#"Requêtes fusionnées3", "Targets_Data_Year", {"Year", "Qty"}, {"Targets_Data_Year.Year", "Targets_Data_Year.Qty"})
Here is the final table that will be loaded in Excel (and will be used as source for a pivot table) :
Here is the table containing sales per year ("Targets_Data_Year"):
Here is the table containing sales targets ("Targets") - I want to add column 2014,2015,2016... (containing qty/sales of the above table)
Hello,
have you managed to find a solution?
Something like this would benefit me so much.