Dynamic matrix visual column headers

[SonaliDhotre]

We want the column names in the matrix should be dynamic and the data shown should also be dynamic

Snapshot Date	<last year>	<this year>	<next year>	R3M	R6M	R9M	R12M
Jan 2021	1,755,692	2,298,284	2,298,284	2,298,284	2,528,069	2,148,843	2,148,843
Feb 2021	1,755,692	1,685,614	1,998,530	1,998,530	2,198,322	1,868,608	1,868,608
March 2021	1,755,692	1,685,614	1,969,587	1,998,530	2,198,322	1,868,608	1,868,608
April 2021	1,755,692	1,685,614	1,969,587	1,804,455	2,198,322	1,868,608	1,868,608

in the above example <last year>, <this year>, <next year> should show actual year and other column headers are static.
can you please help me with how I can achieve this?
The row data is in the following format

Snapshot Date	Period	Key figure	Value
Jan 2021	Jan 2021	k1	200
Feb 2021	Feb 2021	k2	300
March 2021	March 2021	k1	500
April 2021	April 2021	k2	550

Column headers are based on period year

[AlexisOlson · Accepted solution]

I can't think of a nice clean way to do this.

For a less clean method, you may be interested in my answer here:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrix

[VahidDM · Accepted solution]

Hi @SonaliDhotre 

Not sure, but I think you can use calculated Group.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[AlexisOlson · Accepted solution]

I can't think of a nice clean way to do this.

For a less clean method, you may be interested in my answer here:
https://stackoverflow.com/questions/52632713/custom-aggregate-column-in-power-bi-matrix