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!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount 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.
User | Count |
---|---|
98 | |
76 | |
75 | |
49 | |
27 |