how to add calculate columns in dimension level in matrix visual

[Anonymous]

Hi, experts, I have a problem in display some measures, here is the data:

I swithed the rows into values in matrix:

but the visual should be like this, a summary of top 3 months should be added, and similiary the gap of sum(202201-202206）and sum(202207-202212) should be added in a column

so how to add such a summary value in rows of yearmonth column? Thank you.

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Anonymous]

Thanks for your reminding, here is the sample data:

yearmonth	val1	val2	val3
202201	2	3	5
202202	3	7	1
202203	3	2	9
202204	2	2	7
202205	2	2	3
202206	3	6	6

and here is the result should be displayed in matrix after swith the rows into values:

besides the yearmonth column, 2 other calculates column should be added, cal 1 is the summary of 202201, 202202,202203; cal 2is the summary of 202204, 202205,202206:

	202201	202202	202203	202204	202205	202206	cal1	cal2
val1	2	3	3	2	2	3	8	7
val2	3	7	2	2	2	6	12	10
val3	5	1	9	7	3	6	15	16

[lbendlin]

here  is an (admittedly crude) poposal of how this could be achieved.  

Ideally you would want to rethink that, by introducing Quarters, for example.

[Anonymous]

Thank you, but the data in the file is not the same with the sample data because the the raw data val1, val2, val3 is columns rather the value of one column, so this method no quite solved my problem

[lbendlin]

 because the the raw data val1, val2, val3 is columns

You don't want that pattern.  Power BI wants long and narrow tables, and does not like dynamic column counts.