cancel
Showing results 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

New Member

Calculate difference from previous month

I have the following table that looks as such

I am using the following formula to count all orders

`numOrders = COUNTROWS(AllOrders)`

I then calculate the total retailed orders based on whether there is a retail date

```Total Retailed = CALCULATE (
[numOrders],
FILTER (
'AllOrders',
AND (
NOT ( ISBLANK ( 'AllOrders'[RetailDate] ) ),
DATEVALUE(AllOrders[RetailDate]) <= MAX ( BasicCalendarUS[DateKey] )
)
))```

I then calculate the total retailed orders year to date by using this formula

```Total Retailed  YTD = CALCULATE (
[Total Retailed],
FILTER (
'AllOrders',
YEAR( 'AllOrders'[RetailDate] ) = YEAR( MAX ( BasicCalendarUS[DateKey] ) )
)
)```

Now what I want is to have it do a month over month calculation to see the difference. I am having trouble picking up a formula that looks to the previous month and subtracts it from the current month to give me the number.

Below is a screenshot of what I am looking for. ( I left out some months for simplicity)

Any help would be greatly appreciated

Thanks!

Derek

2 REPLIES 2
Community Support

Hi @dkbollig,

In my opinion, you can use a calculate column to store the running total, then write a measure to get the running total of previous month and calculate the different between current value and previous.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
Post Prodigy

@v-shex-msftSounds like the idea. I can't see any operations in there so that might be something to consider.

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.

Power BI Monthly Update - August 2024

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

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors
Top Kudoed Authors