Sub-Headers in Excel File Data Source

[StuartSmith]

I have an excel data source that has a header and then a sub-header and unsure how to handle it without maybe removing the month header and just sticking with the CW (Calendar Week) Header, although this isnt my data source.

Any Ideas?

[Mariusz]

Hi @StuartSmith 

Please see the attached file with the transformation applied, please follow the steps in Power Query Editor, 

Any questions please let me know.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[amitchandak]

You have an unpivot option but two-level will not help.

https://radacad.com/pivot-and-unpivot-with-power-bi

@ImkeF , can you help?

[ImkeF]

Hi @StuartSmith  

please check the function I made for this task here: https://www.thebiccountant.com/2017/06/19/unpivot-by-number-of-columns-and-rows-in-powerbi-and-power... 

Also, here is some guidelines on how to attach sample data in this forum: https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-... 

[StuartSmith]

@ImkeF that looks ideal for my data, one problem, How do i ge the code in to Power BI. I have been searching\googling, but know the code must go into the "Advanced Editor", but when I open Avacned Editor, there is already some code there, so I pasted your code below, but that errors.  

I have watched lots of youtube clips, but again, not much help.

Thanks,

[StuartSmith]

@ImkeF  Ignore my last comment as figured it out.

[Mariusz]

Hi @StuartSmith 

You can do some Power Query Transformation and keep both if that's what you after?

If you need some help, please provide the data sample is useable format ( something that can be imported or pasted ) into the Power Query Editor

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[StuartSmith]

Thanks,  I have hoping to attach the file, but no option for that. I have tried posting the table from Excel, but it keeps on failing.  Sorry to be a pain, whats the best we to get you the table example.