Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I´m having trouble understanding how to calculate a measure from a cummulative column that I get from the dataset.
I have the following table:
- Date (aaaaa-mm-dd)
- Account
- Value (cummulative value for the account in the fiscal year starting in July)
The table is like this:
I also have a Calendar table and a dimension table for Account (levels: category-sucategory-account).
I´m trying to create a new measure that calculates the quarterly data, as the sum of the three months in the quarter, so I can visualize the following for each category of accounts (in this example only Account A):
Q1 | 35
Q2 | 24
I can´t use the sum of AMOUNT because I would be cummulating something that´s already cummulated.
Does anyone know how to solve this?
I would be very grateful for your help!!
You may try using SUMX.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!