Forum Discussion

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Cumulative Total Help - Slicer sets starting date

Hello -    Working on a basic running/cumulative total. I have it working but it is grabbing all dates in my table. I'd like it to compute starting from the date present in a slicer. I've poked aro...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
6 years ago

Hi,

Does this measure work?

=CALCULATE(COUNTRWS(WKO),DATESBETWEEN('Calendar'[Date],MIN('Calendar'[Date]),TODAY()))

Ensure that the Data slicer is built from the Calendar table and you select 1/1/2020 there.

Hope this helps.

Nicho247's avatar
Nicho247
Icon for Helper III rankHelper III
6 years ago

Hello Ashish -

 

Thank you for your recommendation. Unfortunately this is just outputting flat lines across all times. This is not a running total.

 

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    6 years ago

    Hi,

    Does this measure work?

    =CALCULATE(COUNTROWS(WKO),DATESYTD(Calendar[Date],"31/12"))

    • Nicho247's avatar
      Nicho247
      Icon for Helper III rankHelper III
      6 years ago

      Hello Ashish - No sir. This is similiar to last time with a flat bar (not running total).

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Icon for Super User rankSuper User
        6 years ago

        Hi,

        Share the link from where i can download your PBI file.