How to calculate the accumulated sum of the previous month?

[edwinchagas]

Hello everyone

I have a table with the values ​​below.

I can show the sum of the base value of the current month (according to the selected date filter), but I would also like to show the accumulated sum value of the previous month.

The sum of the current month is calculated as follows:

Sum Base Actual month = CALCULATE(COUNTROWS['Table'],FILTER(ALLSELECTED('Calendar'),'Calendar'[Date] <= EOMONTH(TODAY(),0)))

The value (per day) of the previous month is calculated:

Sum Base Previous month = CALCULATE(COUNTROWS['Table'],DATEADD('Calendar'[Date],-1,MONTH))

I need to show the total value of the previous month (382) in all rows (as well as Sum Base Actual Month). How could I do this?

[Anonymous · Accepted solution]

Hi @edwinchagas ,

You can try this measure.

Measure 3 = 
VAR _count =
    CALCULATE (
        COUNTROWS ( 'Table' ),
        FILTER (
            ALL ( 'Calendar' ),
            'Calendar'[Date] <= EOMONTH ( MAX ( 'Calendar'[Date] ), -1 )
                && 'Calendar'[Date]
                    >= EOMONTH ( MAX ( 'Calendar'[Date] ), -2 ) + 1
        )
    )
RETURN
    _count

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[edwinchagas]

Wow!

Your solution is working like a charm!

Thank you!

[lbendlin]

but I would also like to show the accumulated sum value of the previous month.

Since that month is completely in the past the running total equals the sum.   Are you trying to show partial sums somehow?

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.  If possible, could you ensure that data in that file is in English?