Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello everyone,
I'm trying to achieve the following (even though I'm not sure it's achievable):
I have a matrix with a few columns. All of the values in the matrix are measures, only the year column is an actual column. Everything else are measures.
The last column "To execute" is calculated by subtracting ("Grand total" - "Executed"). If there is a positive value in this column, I need to add it to the next year's grand total. In this case, the grand total for 2024 would be the initial 300 + the remaining 150 from the last column.
Considering this table is entirely made of measures and not calculated columns, and therefore I don't have row indeces, is this possible?
Extra info, in case it is relevant:
Thank you in advance to anyone who might take the time to analyze this.
Hi,
Share the download link of the PBI file.
you should avoid computing with nested measures. Instead, apply the entire business logic in its own measure.
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