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

Helper III

## Calculating diviation between Column and Measure

Hello,

I'd like to ask a fairly dumb question, sorry.

I have a column with Amount, and I have a measure Rolling Average.

How can I calculate the difference between the two? I want to show the items who have the largest diviation for this month compared to the rolling average (the weird outliers basically).

should it be a column or a measure? can you just do 1 minus the other?

edit: edited the title to be more clear

1 ACCEPTED SOLUTION
Community Champion

you can subtract two measures or an aggregation of column e.g. SUM & a measure

I would create a new measure which would be SUM of the Amount column, and subtract that from the Rolling average measure

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

2 REPLIES 2
Community Champion

you can subtract two measures or an aggregation of column e.g. SUM & a measure

I would create a new measure which would be SUM of the Amount column, and subtract that from the Rolling average measure

Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Helper III

Thank you @Stachu for your quick reply and for your solution.

## Helpful resources

Announcements

#### Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

#### Join our Community Sticker Challenge

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

#### 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