Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
JVolk
Frequent Visitor

Difference between Columns dynamically

Qtr Difference.PNG

Looking for a measure formula to dynamically calculate the difference between Qtr 3 and Qtr 4.  

5 REPLIES 5
Greg_Deckler
Community Champion
Community Champion

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.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

The Values are a count of completed demos, while the columns are the overviews scheduled by quarter.

JVolk
Frequent Visitor

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:

 

fields.PNG

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors