Forum Discussion
Matrix calculation from another.
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.
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