Data of the previous month to the selected month

[harson]

Hi,

Can somebody help me please

I would like to have the data of the previous month to the selected month using SetAnalysis.

Here are the data I have

I'd like to have if I select 04/01/2018 or 01/01/2018 the Sum of Value_FD where Month = Dec-2018 (45) and so on... If I select 25/12/2017 or 03/12/2017 or 21/12/2017 I'll have the Sum of Value_FD where Month = Nov-2018 (61)

Thanks in advance

Part of data :

DATA :

LOAD Date(FULL_DATE) as DATE,

Value_FD

INLINE [

    FULL_DATE, Value_FD

    01/01/2018, 5

    04/01/2018, 5

    25/12/2017, 10

    03/12/2017, 17

    21/12/2017, 18

    02/11/2017, 56

    05/11/2017, 5

];

[sunny_talwar]

Where do you want to show this value in a text box object?

[harson]

yes

[sunny_talwar · Accepted solution]

Check this for text box object

=Sum({<DATE = {"$(='>=' & Date(MonthStart(Max(DATE), -1)) & '<' & Date(MonthStart(Max(DATE))))"}>}Value_FD)

[harson]

Thanks stalwar1

You are the best.