Forum Discussion

vani's avatar
vani
Helper I
10 years ago
Solved

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])...
Need Help
  • v-haibl-msft's avatar
    v-haibl-msft
    10 years ago

    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

v-haibl-msft's avatar
v-haibl-msft
Microsoft Employee
10 years ago

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