Accumulated values in SPLM, in the same number of days

[sara_pinto15]

Hello,

I hope you are good.

I have difficulty in having the accumulated value of the last month, for the same days.

What I want is represented in the following image:

The measurements I have at the moment are:

.Value1_MTD =

 TOTALMTD(

     [.Value1],

     dCalendar[Date])

.Value2_SPLM_Accumulated =

 IF(SELECTEDVALUE('dCalendar'[Day])=1,0,

 CALCULATE(

     [.Value1_MTD],

     DATEADD('dCalendar'[Date],-1,MONTH)

    )

    )

Can you help me?

Thanks for your attention.

[tamerj1 · Accepted solution]

Hi @sara_pinto15 

please try

Value2_SPLM_Accumulated =
MAXX (
SUMMARIZE ( 'dCalendar', 'dCalendar'[CalendarDate], 'dCalendar'[Day] ),
IF (
'dCalendar'[Day] = 1,
0,
CALCULATE ( [.Value1_MTD], DATEADD ( 'dCalendar'[Date], -1, MONTH ) )
)
)

[sara_pinto15]

It works! Thank you 😊