Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more
Looking for a measure formula to dynamically calculate the difference between Qtr 3 and Qtr 4.
Are Qtr 3 and Qtr 4 columns or measures?
If they are measures, you could just do:
Measure = [Qtr 4] - [Qtr 3]
If they are columns, then are these being summed or is there some other aggregation going on? Whatever the aggregation (let's assume SUM) then it would look like:
Measure = SUM([Qtr 4]) - SUM([Qtr 3])
Otherwise, there is not enough information to properly articulate a solution.
Sorry I should have been more specific. My columns are date fields summarized by quarter.
So how are you getting a whole number value from a Date field? Can you post some sample data?
The Values are a count of completed demos, while the columns are the overviews scheduled by quarter.
For clarification I am counting any row where the date field (overview_scheduled_at__c) is in quarter 3 and quarter 4 displayed as columns. here is the data:
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 84 | |
| 49 | |
| 38 | |
| 31 | |
| 30 |