Forum Discussion
StuartSmith
Power Participant
Power ParticipantSub-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 ...
StuartSmithPower Participant
Power ParticipantImkeF 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,
StuartSmithPower Participant
Power ParticipantImkeF Ignore my last comment as figured it out.