Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
Hello Experts,
For the below i want to make, for column 31 header should be 1st row and the remaining column header should be 2row how can i do it, If all are in same row i can use "use fitst row as header" but they are in different rows. Please help me experts.
Solved! Go to Solution.
Hi,
You can do this in power query:
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Dear @Universe24 please refer to the attached pbi and see how it's solved in M language.
https://drive.google.com/file/d/12kikF9Ps038k4SwTtdV42y8ibuYdSAxB/view?usp=share_link
let me know if you need any additional support.