Forum Discussion

DanielRodriguez's avatar
DanielRodriguez
Regular Visitor
8 years ago

Hi,

in your excel you have the column year, so you need charge this column in power bi.

 

 

Anonymous's avatar
Anonymous
Not applicable
8 years ago

How do i do that Daniel?

 

Please explain like I'm 5 (ELI5).

 

Thanks.

  • 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