Forum Discussion
Matrix calculation from another.
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.
6 Replies
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-Forum/ba-p/963216
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/1447523I 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.
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-Forum/ba-p/963216
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/1447523
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.
Is that Pivot table coming from Excel? If yes, can you post the sample Excel file?
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:
