Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Syndicate_Admin
Administrator
Administrator

Power query Changer Headers

Hey,
I have this table that i would like to change the headers to the date and have the equal data below please?

i tried transpose put gives me  a strange result.

1 ACCEPTED SOLUTION
v-stephen-msft
Community Support
Community Support

Hi @loopingmurdock,

 

There's a feature called 'Use First Row As Headers' which you could try.

Solved: How make nth row as header in Power BI desktop ? - Microsoft Power BI Community

Solved: Promote headers from a specific row - Microsoft Power BI Community

Promote or demote column headers - Power Query | Microsoft Docs

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-stephen-msft
Community Support
Community Support

Hi @loopingmurdock,

 

There's a feature called 'Use First Row As Headers' which you could try.

Solved: How make nth row as header in Power BI desktop ? - Microsoft Power BI Community

Solved: Promote headers from a specific row - Microsoft Power BI Community

Promote or demote column headers - Power Query | Microsoft Docs

 

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Vijay_A_Verma
Super User
Super User

If you can also post the expected result, then giving answer would be easier for us.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors