Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Running Total

I have a table with sales by month and year and wtih some months zero, I am trying to create a line chart that shows running total throughout the year, but the blank values are getting me and I can't...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Super User
6 years ago

Hi,

What result are you expecting?

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I am looking for a total that adds up the prior months, but then also just repeats previous month until a value comes in.  

     

    So that the line is continious 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I would use some of the time intelligent functions that DAX has, i.e. TOTALYTD. This should make your lines continuous.

      Sales YTD = TOTALYTD( [Sales]; Date[Date]) // Returns the running total for the year
      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        SumSalesYTD = TOTALYTD(sum('Sales Data Structure'[INVOICED IN USD]),DATESYTD('Date'[Date]))
         
        This is the measure I use and it produces this result