Matrix calculation from another.

[Syndicate_Admin]

I have a matrix in which two periods are compared and in these as values a quantity is used, of lso values of that matrix I need to obtain some accounts as an average between the total to find the percentage and then between certain months. How can I create that resulting graph or that they keep recommends. This made in excel is very easy but when passing it to power bi everything changes because I can not use the information obtained from the matrix.

[Syndicate_Admin]

It does not let me add files of the extension of excel, I will show how it looks in power bi to exemplify better but because you understand the idea I think:

[Syndicate_Admin]

I have the following matrix or pivot table: . Low Period High Period202207202208202209202210202211202212202301202302202303202304202305202306(blank)Grand TotalGrand Total123452705736377576757185487343101907908459942811129212861611172424017993338262

202206	12345	12954	9968	18241	13427	10255	9567	7417	7076	6443	5944	4177	127704	245518
202207		14103	11308	8902	18015	12871	11627	8456	7934	7262	7059	5280	135265	248082
202208			15101	14648	11730	22332	15983	11572	10744	10191	10681	7331	170895	301208
202209				15884	13939	13187	19894	12926	11444	10822	11169	8534	168481	286280
202210					14743	12561	11932	17154	12801	10770	11126	8153	160898	260138
202211						16137	15919	12667	16408	13891	11404	7786	173604	267816
202212							16985	11095	11082	19778	16647	9987	177156	262730
202301								9558	10613	9849	16679	12668	171259	230626
202302									11326	10276	10762	14579	190929	237872
202303										12010	13868	8876	239132	273886
202304											13277	9653	204540	227470
202305												14700	234636	249336
202306													247300	247300

This graph can be obtained as a visual object, I need to use the values of each high period to create a measure, being such data so specific I need to know how I can do it because first I must divide each data by the total and then use groups of total, 6 and 4 to obtain the variance or mean in another matrix graph or table. I really need help with dax to know how to make the code with which to obtain each data of those and get that total that appears for each month the answer looks something like that.

	MediaMes	Early	Sixth
202303	4,64%	18,57%	18,57%
202304	4,60%	18,42%	25,88%
202305	34,00%	23,20%	23,20%
202306	23,13%	23,20%	12,31%
202307	23,21%	23,12%	22,12%

This last table is conceptual the data does not give that information but it is to exemplify the problem.

[lbendlin]

Is that Pivot table coming from Excel?  If yes, can you post the sample Excel file?

[Syndicate_Admin]

I do not have specific test data since it is a very sequential issue you could say, I will send a screenshot and I hope you can help me. The matrix I have is as follows

And as if it were an excel I need to calculate from those values an average measure, I mean that I need to use for example to 202206 the first 4 values and calculate the mean, then with 6 values and in the case of those who do not have to use the last ones. My problem is that interaction that I need to know how to find those calculations using dax or how I can implement those already obtained in a new calculation.

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...