Calculate previous month value based on selected dates

[Anonymous]

I have following data set:

Date	Value
1.2.2019	400
15.2.2019	50
23.2.2019	100
24.2.2019	150
5.3.2019	80
19.3.2019	20
23.3.2019	35
25.3.2019	70
1.4.2019	15

I like to give end user a change to filter dates and after that calculate value for the last month... based on selected values:

	Value	PrevMonth
23.2.2019	100
24.2.2019	150
5.3.2019	80	250
19.3.2019	20	250
1.4.2019	15	100

I have been trying to do this many ways already and don't seem to get it to work. Can anyone help me with this?

[v-cherch-msft · Accepted solution]

Hi @Anonymous 

You may try below measure:

Measure = 
CALCULATE (
    SUM ( Table1[Value] ),
    FILTER (
        ALLSELECTED ( Table1 ),
        MONTH ( Table1[Date] )
            = MONTH ( MAX ( Table1[Date] ) ) - 1
    )
)

Regards,

Cherie

[Anonymous]

Hi @v-cherch-msft ,

It is not work when we have 2 years of data i.e., 2018 and 2019. Is is working when we have 1 year data alone. It is getting summed up for nov month 2019 as well as 2018 whenever the month value is returning as 11.

Thanks