Month over Month in Power BI (MoM)

Subscribe: bit.ly/3i3WN4p Previous Month Calculation
Last Month Sales_ = calculate(sum('Sample - Superstore_Orders'[Sales]), PARALLELPERIOD('Sample - Superstore_Orders'[MonthYear], -1, MONTH))
Month Over Month Calculation
Month Over Month_ = iferror((sum('Sample - Superstore_Orders'[Sales]) - [Last Month Sales_]) / [Last Month Sales_],blank())

[@DarcyWhyte]

you can use the DIVIDE function to get rid of the infinity problem by the way...

[@adele62105]

super simple - nice work!

[@ynteractivetraining]

Thanks a lot!

[@deeswift-z1h]

do we need the dates from calendar table or can I get it from my fact tbale itself
?
As, I have data till march but its comparing for April as well and summing it to 0 (for MOM comparison )

[@manoj1464]

In similar to this instead of month I have categories like 1 2 3 and so on I want the dashboard to show the difference between 1 and 2 , 2 and 3 so on is there a way to do

[@Mahesh717]

hey
what if we use datesAdd instead of parallel period.. will it work...

[@SenpaiMD]

it works yes'

[@arhamnadeem6702]

at 0:50 when you remove the date hierarchy. how does your trendline automatically sum the data to show month+year based sales. I have daily sales data where the date has duplicates as there are multiple orders on a single date. everytime i try a formula to calculate the previous month's sales, i get an error saying that there are duplicates in the dates

[@MrTerenceJonathan]

Hi this is really good stuff I need a help on my data were I have the year from 2021~23 along with the dates & months in a column in such a senario how can I measure the YoY & MoM. Please guide. Thanks Terence

[@ynteractivetraining]

Glad you like it! I can help if you email me at [e-mail]

[@MK-uk7wp]

Hello Sir. I did the last month calc but only got the sum and not the amount listed by month. Any advice would be greatly appreciated.!

[@ynteractivetraining]

Glad to help further. just send me a message at [e-mail]

[@nishthadutta4756]

how did you solve this issue. I am facing the same