map to column header

[chadb]

I hope some can help. I have an excel sheet that has the a list of the months 1-12 as the header for the columns. In power-bi i have a table to that the months in the rows. Is there anyway to map the query of the excel data base to the query of the month table. The data below the list of months is the revenue for that item in that month. In normal mapping it will attempt to map the data in the cell and not the data in the header. Please help!!! 

[v-piga-msft]

Hi @chadb,

ssugar 's answer is helpful.  Please have a try.

If you want to unpivot your month colunm from column to row, you could refer to this blog about unpivot.

If you have solved your problem, please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share some data sample and your desired output so that we could help further on it easier.

Best Regards,

Cherry

[ssugar · Accepted solution]

In Power BI desktop, once you import the data from Excel, it sounds like you'll want to unpivot the month columns.  That will give you the months in rows.

It's always easier to give more specific help if you provide sample data.