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

[Mk60]

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

    )

[Ritaf1983 · Accepted solution]

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

[Mk60]

Ritaf1983,

Thank you so much!

[Ritaf1983]

Happy to help 🙂