Running Total

Question

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

ashish_mathur · Answer

Hi,
What result are you expecting?

v-chuncz-msft · Answer

Anonymous&nbsp;
&nbsp;
You may check if the following post helps.
https://community.powerbi.com/t5/Desktop/Dax-Measure-Fill-Down-Value/m-p/594415#M282232

anonymous · Answer

I am looking for a total that adds up the prior months, but then also just repeats previous month until a value comes in.&nbsp;&nbsp;&nbsp;So that the line is continious&nbsp;

anonymous · Answer

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 · Answer

SumSalesYTD = TOTALYTD(sum('Sales Data Structure'[INVOICED IN USD]),DATESYTD('Date'[Date]))&nbsp;This is the measure I use and it produces this result&nbsp;&nbsp;

Forum Discussion

Running Total

6 Replies

Related content

Running Totals

Running total

Waterfall Charts with running totals

SumX? - cumulative running total

Tableau to PowerBI Running Totals Issue