Month on month/ Year on Year change

[kb177]

Hello

I get data in below format from other team, I want to add MOM difference and  also yoy difference once year changes to 2023,  when I'm trying to create measure Amount column is not showing in after using Calculate function

Year	Amount
Sep-22	30000
Oct-22	31000
Nov-22	29000
Dec-22	35000

[kb177]

Thanks Amit It worked.

Can we show total difference (+/-) of Last month vs current month in card visual 

[amitchandak · Accepted solution]

@kb177 , I usually prefer to create YearMonth YYYYMM or date and then join it with YearMonth/date table

Date = datevalues("01-"&[Year])

Join with date table

and have measure like

MTD Sales = CALCULATE(SUM(Sales[Amount]),DATESMTD('Date'[Date]))
last MTD Sales = CALCULATE(SUM(Sales[Amount]),DATESMTD(dateadd('Date'[Date],-1,MONTH)))
last month Sales = CALCULATE(SUM(Sales[Amount]),previousmonth('Date'[Date]))

For more refer

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
https://www.youtube.com/watch?v=6LUBbvcxtKA

Time Intelligence, DATESMTD, DATESQTD, DATESYTD, Week On Week, Week Till Date, Custom Period on Period,
Custom Period till date: https://youtu.be/aU2aKbnHuWs&t=145s