Forum Discussion

Siboska's avatar
Siboska
Icon for Helper II rankHelper II
4 years ago
Solved

Calculate running totals between 2 date

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.

Need Dax
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    4 years ago

    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] ) )
    )
)

     

     

     

3 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    4 years ago

    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's avatar
      Siboska
      Icon for Helper II rankHelper II
      4 years ago

      It will still select all dates prior to my Date slicer

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Icon for Super User rankSuper User
        4 years ago

        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.