Calculate running totals between 2 date

[Siboska]

Hi, 

I'm trying to calculate the running totals between my period slicer. 
Atm. I can only manage to filter on max day selected and not the min with the following formula:

[Total Budgetupdated] = A calculated Measure
Period[Date] = My period tabel which the slicer isreferencing from. 

Cumulative Total Budget =

    CALCULATE (

        [Total Budget updated],

        FILTER (

            ALL ( Period[Date] ),

            Period[Date] <= MAX ( ( Period[Date] ) )

        )



So my goal is to incorporate  Period[Date] >= MIN ( ( Period[Date] ) In my measure.

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your datamodel looks like, but please try using ALLSELECTED dax function instead of ALL, and check whether it suits your requirement.

Cumulative Total Budget =
CALCULATE (
    [Total Budget updated],
    FILTER (
        ALLSELECTED ( Period[Date] ),
        Period[Date] <= MAX ( ( Period[Date] ) )
    )
)

[Siboska]

It will still select all dates prior to my Date slicer

[Jihwan_Kim]

Hi,

Thank you for your feedback.

If it is OK with you, please share your sample pbix file's link here, and then I can try to look into it to come up with a more accurate solution.
Thank you.