Add multiple column headers to matrix or table visual

[dkdirenzo]

Hi, I need to create a powerbi visual that can be exported to excel in the same format as the current template which is used for an upload to the cloud. I am having trouble adding the required data to the visual and am not sure it is possible - this is what i need the header of the table to look like but I can only get one row to display in powerbi:

Is this possible or does anyone have a potential workaround?

[lbendlin]

That's not what Power BI is for. DAX queries fundamentally return tables.  You can experiment with ROLLUPADDISSUBTOTAL and other exotic stuff but it will be easier to do the templat-y stuff elsewhere, like in Excel.