Forum Discussion
Duplicate values while merging columns
Hi all! I have a Forecast table with Company/ Product/ Forecast columns: I have another table with Product/ Sales but NO Company: If I try to merge the Sales into the Fo...
Hi alicia_mtz,
I've prepared the same result you are requesting by adding the company field in the sales table which stated "Nike" for all the rows, and by appending the sales table with the forecast table. I just used the PQ ribbons which produced the following M codes as I am not that conversant with M.
the first occurrence of each Company
You will need to define what you mean by that. Row numbers are not directly exposed in Power Query, so you need to either add indexes or implement a manual row check.
Is there a way to merge it but putting all sales in the first occurrence of each Company
All sales of what? each product? That's what you already did. How are you planning to split the sales across the companies?