Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Good Morning,
I need to perform a cumulative sum, according to the year and month filters selected in the data segmentation.
As in the matrix below with status of "ok" beside it, it works, when I put the months in the line field.
But I need to assemble according to the matrix structure above ( 1 ), as a summary.
I need that: 1° - When selecting the year, bring the sum of the selected year.
2nd - When selecting the month, bring the sum of the selected month + the previous months of that chosen year.
Example: Total "PA Safra Mes" with no filter applied, should return 2,894,363, which is the sum of the base of all years.
Year filter performed, value to be returned, 1,528,199, which is the total of the chosen year.
Filter for the month of June, value to be returned, 484,560, which is the sum of June + plus previous months (April 25,200 + May 214,272 + June 245,088 = 484,560)
Note: My year starts in April, just for clarification.
Hi @hudsonvj ,
Could you pls share your pbix file and remember to remove confidential data.
Best Regards
Lucien
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.