This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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:
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 32 | |
| 26 | |
| 21 | |
| 20 | |
| 15 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 28 | |
| 24 | |
| 22 |