Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Add year column

Hi Power BI experts :-)   How do I allocate existing data to a year? Do I create a new column in the Excel spreadsheet? Or the Query Editor?   I've created a dashboard from an Excel spreadsheet o...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks for your response parry2k. Would I have to:

  1. add a column for 'Year'
  2. then connect Power BI to the modified Excel spreadsheet
  3. then run 'Edit Query' and run through all my 'Applied Steps' again?

 

Or is there a quicker way? I've got five years of data that I must add the year to (2012 - 2016). 

 

Should I keep the data for different years in separate spreadsheets or merge them all into one?

 

Here are all the steps I applied to transform the data (right side of screen):

 

 

 

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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: