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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Mk60
Resolver I
Resolver I

Calculation for Quarter-over-Quarter change expressed in dollars, not as percentage?

I am using this calulation that was recomended by "New quick measure" in my model, and results are accurate, but only come as percent of change (%), and I need the change to be in dollars, (nominal variance). Please let me know if I can make change to this calculation to give me actual variances in balances, (numbers instead of % of change). Thank you so much!

Here's dax calculations I am using:

QoQ Change GL =
VAR __PREV_QUARTER = CALCULATE(
    SUM('Query1'[GL_BALANCE]),
    DATEADD(
        'Query1'[POSTING_DATE].[Date],
        -1,
        QUARTER
    )
)
RETURN
    DIVIDE(
        SUM(
            'Query1'[GL_BALANCE]
        )
        - __PREV_QUARTER,
        __PREV_QUARTER
    )
1 ACCEPTED SOLUTION
Ritaf1983
Super User
Super User

Hi @Mk60 
You need the same but to subtract instead of devide

something like 

QoQ Change GL =
VAR __PREV_QUARTER = CALCULATE(
    SUM('Query1'[GL_BALANCE]),
    DATEADD(
        'Query1'[POSTING_DATE].[Date],
        -1,
        QUARTER
    )
)
RETURN
  
        SUM(
            'Query1'[GL_BALANCE])-__PREV_QUARTER
        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

View solution in original post

3 REPLIES 3
Ritaf1983
Super User
Super User

Hi @Mk60 
You need the same but to subtract instead of devide

something like 

QoQ Change GL =
VAR __PREV_QUARTER = CALCULATE(
    SUM('Query1'[GL_BALANCE]),
    DATEADD(
        'Query1'[POSTING_DATE].[Date],
        -1,
        QUARTER
    )
)
RETURN
  
        SUM(
            'Query1'[GL_BALANCE])-__PREV_QUARTER
        If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Ritaf1983,

Thank you so much!

Happy to help 🙂

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.