cancel
Showing results for
Did you mean:
Highlighted
New Member

## Calculation for Last month Same Period

Hi All,

I am trying to calculate a measure for last month same period i.e. if today is 7.2.2019, I want to calculate sum(sales) for last month up to the 2nd day i.e. 6/2/2019. I have researched this and found a formula on most of the posts that I am trying to use but it doesn't give me the correct value.

Any help will be appreciated, thanks in advance!

Formula: Last MTD Sales=
CALCULATE(
Sum('Main'[Sales]),
DATEADD( DATESMTD( Dates[Date] ), -1, MONTH )

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

## Re: Calculation for Last month Same Period

Hi,

Ensure that there is a relationship between the Date column of the Main Table to the Date column of the Calendar Table.  Drag the Date column from the Calednar Table to your slicer/visual and select today's date in the slicer/filter.  Write this measure

Last MTD Sales = CALCULATE(Sum('Main'[Sales]),DATESBETWEEN(Dates[Date],EOMONTH(MIN(Dates[Date]),-2)+1,EDATE(MIN(Dates[Date]),-1))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com
3 REPLIES 3

## Re: Calculation for Last month Same Period

Try this

Formula: Last MTD Sales=
CALCULATE(
Totalmtd(dates[date],Sum('Main'[Sales]),

* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Super User III

## Re: Calculation for Last month Same Period

Hi @AJthacker ,

The syntax of the measure seems ok but without any additional information is difficult to understand what you need and what is the final result you are looking for.

Can you share a sample data and expected result?

Regards,

MFelix

Regards

Miguel Felix

Proud to be a Datanaut!

Super User IV

## Re: Calculation for Last month Same Period

Hi,

Ensure that there is a relationship between the Date column of the Main Table to the Date column of the Calendar Table.  Drag the Date column from the Calednar Table to your slicer/visual and select today's date in the slicer/filter.  Write this measure

Last MTD Sales = CALCULATE(Sum('Main'[Sales]),DATESBETWEEN(Dates[Date],EOMONTH(MIN(Dates[Date]),-2)+1,EDATE(MIN(Dates[Date]),-1))

Hope this helps.

Regards,
Ashish Mathur
http://www.ashishmathur.com

Announcements

#### Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

#### Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

#### Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

#### Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!