Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Power BI - Cumulative Sum over Time using Parameter Inputs Only

Hi

I am trying to draw a line on my Power BI visual that shows the inputs of a parameter, and the cumulate/sum of these results over time. The example is; if I complete 10 tasks a day, how many tasks will be completed over time? If I change the number of tasks to 20 a day how does this cumulative sum change?

 

My calculation so far are:

Task Parameter = GENERATESERIES(10, 30, 1)
Task Parameter Value = SELECTEDVALUE('Task Parameter'[Task Parameter], 10)
I also have a Date table, with start date of 01/08/2023. 
 
So the output - likely a measure due to the dynamic nature of parameters - to visualise would be:
01/08/2023 10
02/08/2023 20
03/08/2023 30
...
 
How can I create this measure seeing as the parameter and date do not have a clear link?
 
Thanks in advance.

 

Need Help
  • parry2k's avatar
    parry2k
    3 years ago

    Anonymous try somethign like this:

     

    Measure = 
CALCULATE ( 
    COUNTROWS ( 'Calendar' ), 
    FILTER ( 
        ALLSELECTED ( 'Calendar'[Date] ), 
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) 
    ) 
) * [Task Parameter Value]

3 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    3 years ago

    Anonymous try somethign like this:

     

    Measure = 
CALCULATE ( 
    COUNTROWS ( 'Calendar' ), 
    FILTER ( 
        ALLSELECTED ( 'Calendar'[Date] ), 
        'Calendar'[Date] <= MAX ( 'Calendar'[Date] ) 
    ) 
) * [Task Parameter Value]
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Works perfectly, thank you parry2k