Add a new column or merge tables in Power Query in Dataflow in Data Factory
I have two tables that I have imported in Power Query DataFlow in Data factory. Table 1 shows forecasts units data for 2 years and table 2 shows shipped data for 6 months. Table 1 (Forecasts) has Parts column, unit price and 24 columns showing the 24 months starting from Jan'23 to Dec'24. I unpivoted those columns in Power Query to get one column as 'Month'. Hence, each FCST part now will have 24 rows of data showing the forecasted units every month for 24 months. In table 2, I have the same Parts Column called Shipped Parts. I grouped the data by part and by month and aggregated by Shipped Qty. It gave me 3 columns. Parts, Month, Qty. Now, I want to see the parts, month, shipped qty and forecasted qty together in this format. Upon doing a merge using either left outer, right outer or full outer joins, I am getting 6 rows for each part for each month. I just want to see Part A, Jan, Shipped units and forecasted units in Jan and for other months. How can I achieve this in Power Query?
