Forum Discussion
Solved
How to associate columns with a certain quarter
Hi, this seems to me like a trivial task, but I fail to figure out how to do it in a simple and straight forward way. I'd like to evaluate the accuracy of a forecast against the actual outcome. ...
You will necessarily need to have a date column in table 1 in order to match the periods with table 2. I know sometimes forecast are flat values but you can use either the first or last day of the quarter/month as reference.
Ok, sounds reasonable, but since each row in Table 1 has four different columns with forecasted volumes (one per quarter) would I then have to transform Table 1 to have four rows for each part number?
ray_aramburo
Super User
Super UserThat's right, you can unpivot it on Power Query.