Forum Discussion
Add year column
This question was solved by Ashish. The solution can be found here:
no you don't need to change anything in your power query steps, just make sure the step where you use removed columns that year (new column) is not removed.
Basically you can go to each step to make sure year column is part of model, no need to change anything.
I've added a year column, along with data from other years.
Do you have any advice on how I'd transform the data to make it organised like it was before? With the Year column in place I'm just getting tangled up when I try to transform the data into the nice table I had when there was just one year of data.
Thanks so much. Here's how the data looked when there was just one year. I assumed that I just needed to add another column with the year: