cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Helper II

## Difference between two amounts (Measures or columns)

Hi All,

I am building a dashboard off sales data with sales values, back order amount values, open order amount values etc.

I have a trend graph showing back order amount values and open order amount by month.

I am looking for a dax function to calculate the difference between the 2 measures (back order amount and open order amount). Please note that the x axis is a drill down so it can be drilled down by quater, week etc. I will prefer for this dax function to take the drill down values into consideration.

Please see image of graph below

1 ACCEPTED SOLUTION
Super User

Try this:

Variance = [Back Order Amount]-[Open Order Amount]

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

3 REPLIES 3
Super User

Try this:

Variance = [Back Order Amount]-[Open Order Amount]

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Helper II

That worked Sir. What if i wanted to create the percent difference of between the two?

Super User

Percent Variance =
Var _Variance =[B
ack Order Amount]-[Open Order Amount]
return
_Variance/[Back Order Amount]   //or _Variance/[Open Order Amount]

Change the format to percentage.

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

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

#### Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors