cancel
Showing results for
Did you mean:
Helper I

## Sum up to current month

Hi Guys,
I'm doing the sum of sales considering project and module, but I need to consider only sales that were made up to the month before the current one. How could I do this?

This is the formula I'm using

``````Total repasses por produto =

CALCULATE(

1 ACCEPTED SOLUTION
Resolver I
Hi,
Use this calculation:

Max sales2 = CALCULATE(SUM(Sheet2[Sales]),FILTER(Sheet2, Sheet2[Date] <= EOMONTH(NOW(),-2)+1))

Output:

2 REPLIES 2
Resolver I
Hi,
Use this calculation:

Max sales2 = CALCULATE(SUM(Sheet2[Sales]),FILTER(Sheet2, Sheet2[Date] <= EOMONTH(NOW(),-2)+1))

Output:

Helper I

@Priya1969 Its worked perfectly. Thaniks so much

Announcements

#### Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

#### Power BI March 2023 Update

Find out more about the March 2023 update.

#### March 2023 Events

Find out more about the online and in person events happening in March!

Top Solution Authors
Top Kudoed Authors