Forum Discussion
StuartSmith
6 years agoPower Participant
Sub-Headers in Excel File Data Source
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 ...
StuartSmith
6 years agoPower Participant
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
6 years agoPower Participant
ImkeF Ignore my last comment as figured it out.