cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## Showing wrong Sum

Hello everyone,

I have a measure to calculate the sum of expenses from previous moth which is the following one:

Expenses Last Month= calculate(sum(Gastos[Value]);filter(ALL('Calendar'[Year]);'Calendar'[Year]=[MaxYear]);filter(ALL('Calendar'[Nr Month]);'Calendar'[Nr Month]=[MaxMonth]);ALL('Calendar'[Month]))

I want to show on the table, sum values last month to current day last month  and with that formula, it showing the sum of all the days last month ( 30, but it is suposed to sum just to day 14 ) !

anyone have an idea?

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
Super Contributor

## Re: Showing wrong Sum

@vani

I create two columns in the “Gastos” table with following formulas. Please confirm if it is what you want.

`LastMonth_Date = DATEADD( 'Calendar'[Date] , -1, MONTH )`
```Expenses Last Month =
CALCULATE (
SUM ( Gastos[Value] ),
DATESBETWEEN (
Gastos[Date],
STARTOFMONTH ( Gastos[LastMonth_Date] ),
Gastos[LastMonth_Date]
)
)```

Best Regards,
Herbert

Super Contributor

## Re: Showing wrong Sum

@vani

I create two columns in the “Gastos” table with following formulas. Please confirm if it is what you want.

`LastMonth_Date = DATEADD( 'Calendar'[Date] , -1, MONTH )`
```Expenses Last Month =
CALCULATE (
SUM ( Gastos[Value] ),
DATESBETWEEN (
Gastos[Date],
STARTOFMONTH ( Gastos[LastMonth_Date] ),
Gastos[LastMonth_Date]
)
)```

Best Regards,
Herbert

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 6 members 1,614 guests
Recent signins: