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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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