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

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
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
3 REPLIES 3
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
Resolver I

Ritaf1983,

Thank you so much!

Super User

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

#### Power BI Monthly Update - July 2024

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

#### Fabric Community Update - July 2024

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

Top Solution Authors
Top Kudoed Authors