Show MonthYear and QuarterYear measures side by side in Matrix table

[av9]

Hi

Just wandering if this is even possible. I have a matrix table and I want to show the 'Sales' by MonthYear and the 'Average Sales' by Quarter.

This would be the desired output

I managed to get it working using MonthOffsets in the date table and creating 3 measures to calculate the Sales for each month, but I am not sure if there is a way to dynamically update the measure names to correspond to the Quarter selected in the slicer,

or build this differently altogether. at the moment it does not show the Month name.

any help appreciated.

sample pbix attached

https://drive.google.com/file/d/11z-JiVqRB6-ehYekr9a0AJWGHua2apB9/view?usp=sharing