Running Total

[Anonymous]

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 see how to overcome this. 

I use this formula for the table and it works well, but can't see after reading all the posts on this topic how to close the gap on my problem 

SumSales = var sumsalesmonth =CALCULATE(SUM('Sales Data Structure'[INVOICED IN USD]))

return if(ISBLANK(sumsalesmonth),"0", sumsalesmonth

[v-chuncz-msft]

@Anonymous 

You may check if the following post helps.

https://community.powerbi.com/t5/Desktop/Dax-Measure-Fill-Down-Value/m-p/594415#M282232

[Ashish_Mathur]

Hi,

What result are you expecting?

[Anonymous]

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]

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]

SumSalesYTD = TOTALYTD(sum('Sales Data Structure'[INVOICED IN USD]),DATESYTD('Date'[Date]))

This is the measure I use and it produces this result 

[Anonymous]

I cannot recreate the issue in my own workbook. But I have two suggestions which might work:

• If you have not marked your date table as a date table, then try and do so. It can be done under the 'modeling' tab.
• It is not necessary to have the last DATESYTD in your TOTALYTD formula because it is implicit in the formula.

As you can see in the picture below then when there are no observations in a given month then the line just stays horizontally in my workbook (which I believe is the functionality you are looking for?)