Forum Discussion

parry2k's avatar
parry2k
Super User
8 years ago

Anonymousare you ok to send your excel and pbix t if it doesn't contain sensitive data. Just put it on google drive and share the link, i will send you the transformed pbix.

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thanks parry2kparry2k. You're a legend!!

 

I have a lot of trouble transforming my Excel spreadsheets in the Query Editor so that each variable has its own column.

 

I'm having trouble getting my head around Transpose, Pivot, Unpivot etc

 

With the new column 'Year' added I just can't seem to get the columns set up correctly in the Query Editor like they were when Year wasn't present.

 

And having trouble getting my Excel sheet in the right format.

 

Thanks.

 

Here is the Google Drive link containing the pbix file and the Excel spreadsheet. Data is in the tab "All Data":

 

https://drive.google.com/drive/folders/1n6JbptK6smXQOJazEViXIepAkrl7obxD?usp=sharing 

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      DanielRodriguez thanks for your effort. It's not quite what I'm looking for.

       

      My column headings should be:

      Year, DHB, Population, Enrolled, Base Population

       

      Please see the Edit Query screenshot above.

       

      I had a nice flat table in PBI until I added the year column in order to make a time trend line graph.