Forum Discussion

Icon for Helper III rank

Helper 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...

Icon for Helper III rank

Helper 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.

Icon for Super User rank

Super User

6 years ago

Hi,

Does this measure work?

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

Nicho247
Helper III
6 years ago
Hello Ashish - No sir. This is similiar to last time with a flat bar (not running total).
- Ashish_Mathur
  Super User
  6 years ago
  Hi,
  
  Share the link from where i can download your PBI file.
  - Nicho247
    Helper III
    6 years ago
    Hello Ashish -
    
    Here ya go. This is with some sample data. Should be good enough to replicate the issue. Have a generic calendar table. Have another table with some dates. How to make the slider control the starting point for a running total/cumulative total.
    
    Nick
    
    https://1drv.ms/u/s!AlWk_fvRgbyDoDsGBjSdaNP6D7aS?e=5ezNqx
- Ashish_Mathur
  Super User
  6 years ago
  Hi,
  
  Is this what you want? Download the PBI file from here.
  
  Hope this helps.
  - Nicho247
    Helper III
    6 years ago
    Hello Ashish - No, this doesn't work. These are not running totals and is not affected by the slider. Did you upload the right file? Can you demonstrate how this answers my question? Unsure if I am missing something here.