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...
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...