We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
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:
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 57 | |
| 40 | |
| 36 | |
| 18 | |
| 18 |
| User | Count |
|---|---|
| 70 | |
| 67 | |
| 38 | |
| 34 | |
| 23 |