cancel
Showing results for
Did you mean:
Helper II

## Get Previous month of previous year value

Hi folks,

I would like to get the sale value of previous month of last year.

For example:

In Jan 2021, I wish to get the value in Dec 2019.

In Feb 2021, I wish to get the value in Jan 2020.

In Mar 2021, I wish to get the value in Feb 2020.

....

Any input is highly appreciated. Thanks in advance!

1 ACCEPTED SOLUTION
Super User IV

@tracytran91 , With date table and time intelligence

Try like example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-13,MONTH)))

13 Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-13,Month))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

3 REPLIES 3
Helper II

Thank @amitchandak  @CNENFRNL it works perfectly!!!

Super User IV

@tracytran91 , With date table and time intelligence

Try like example

MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD('Date'[Date]))
last year MTD Sales = CALCULATE(SUM(Sales[Sales Amount]),DATESMTD(dateadd('Date'[Date],-13,MONTH)))

13 Month behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-13,Month))

Power BI — Month on Month with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User III

@tracytran91 , you might use a standard date table in the data model, then leverage DATEADD(Calendar[Date], -13, Month) to retrieve desired month.

Announcements

#### Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group