How to show up row wise monthly and Column wise Calculated Columns result in Power BI

[BracePBI]

Please let me know how to achive this output in matrix visual .  I could achieve the sequence of Calmonths  but unable to display the caculated columns in below way as expected.   Kindly suggest if any special data modelling is required or any other solution.

Thank you all

[BracePBI]

Thank you Alexisolson for the document. its really helpful and i have a question .
My header data of calmonths changes with excel source files.  In that case will this senario work?

I see in your case it is only for three years 

Thank you

[AlexisOlson]

It's possible but you'll probably want to unpivot your months when you load the data to make it easier to work with dynamically.

In the example I linked, both the product and the are dynamic in the way they builder the header table.

[BracePBI]

Hi Alexi,
 I tried to unpivot the months but please let me know how to get sequence of months followed by Calculated columns with out Grouping .

I tried to modify your script  but i could not.

[AlexisOlson]

If you want to mix dimensions and measures as part of the same header, then you're going to have to do some work.

Here's an example I wrote for how you can force this kind of thing to work if you really need to:

Custom aggregate column in power bi matrix