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

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

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
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.