Forum Discussion
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...
SumSalesYTD = TOTALYTD(sum('Sales Data Structure'[INVOICED IN USD]),DATESYTD('Date'[Date]))
This is the measure I use and it produces this result
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?)