cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
vani Regular Visitor
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 ) ! 

lastmonth.png

 

 

 anyone have an idea? 

 

Thanks

1 ACCEPTED SOLUTION

Accepted Solutions
v-haibl-msft Super Contributor
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]
    )
)

Showing wrong Sum_1.jpg

 

Best Regards,
Herbert

1 REPLY 1
v-haibl-msft Super Contributor
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]
    )
)

Showing wrong Sum_1.jpg

 

Best Regards,
Herbert