Forum Discussion

mwvoves's avatar
mwvoves
Regular Visitor
3 years ago
Solved

Promoting headers that don't match

I've got a series of date excel files where there are a few misc rows of data at the top, then has the dates listed horizonally, one per column (see picture below). I'd like to write a query to combi...
Need Help
  • TheoC's avatar
    TheoC
    3 years ago

    Hi mwvoves 

     

    I've attached a PBIX file for you.

     

    Firstly, you want to Transpose the table (in the Transform tab of Power Query), then Unpivot.

     

    You will have to delete your second Applied Step though, as Power BI is automatically determining your first header.

     

    Let me know whether the attached is what you are after. The outputs turn out like this:

     

    Hope this helps!

    Theo 🙂

     

TheoC's avatar
TheoC
Community Champion
3 years ago

Hi mwvoves 

 

I've attached a PBIX file for you.

 

Firstly, you want to Transpose the table (in the Transform tab of Power Query), then Unpivot.

 

You will have to delete your second Applied Step though, as Power BI is automatically determining your first header.

 

Let me know whether the attached is what you are after. The outputs turn out like this:

 

Hope this helps!

Theo 🙂

 

mwvoves's avatar
mwvoves
Regular Visitor
3 years ago

Yes I was able to get it to work after using the transpose step, thank you!!