Forum Discussion
Merged Cells in Source
Try following the article in link. It addresses your issue using PowerQuery/PowerBI using M query expression language.
https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/
This is pretty typical operation needed to analyze free census data that's provided by governments. Which are often organized using multi level headers.
Awesome, I'll give it a read!
Thanks for the quick reply...
Please perform the steps below to handle your data in Power BI Desktop.
1. In Query Editor, choose the first row, then click on “Use First Row as Headers”.
2. Select the first three columns, then click on “Merge Columns”, choose appropriate Separator to merge columns.
3. Select the remaining columns, then click on “Merge Columns” to merge them and you will get expected result.
Regards,
Hi,
So Yes....technically your sollution works. Below you can see my dellema.
(BTW, not sure why the image upload failed on the original post)
I have my source showing budget tracking on project level (column A) for every month (Column C-H), along with the region owner (Column B).
How can I create a link on Columns C-E so that PBI will know that only those columns are linked to January so that it will make creating reports easier.
Sorry for the crappy explination in the original post. And thanks again for helping me.
Try following the article in link. It addresses your issue using PowerQuery/PowerBI using M query expression language.
https://wessexbi.wordpress.com/2014/02/27/unpivot-nested-headings-with-power-query/
This is pretty typical operation needed to analyze free census data that's provided by governments. Which are often organized using multi level headers.
Awesome, I'll give it a read!
Thanks for the quick reply...