DAX DATESYTD Problem with zero values

[Julie H]

Hi,

I'm trying to create a pivot table with items in the row labels, year/month in the column labels and then calculate year to date, here's my formula =CALCULATE(SUM(capex[Amount]),DATESYTD(capex[Date]),ALL(capex))

This works fine unless any of the items have no values in a particular month. Then the pivot table just shows 0 for that month, what I want (not sure if its possible) is for those with a zero value to show the previous month's cumulative value.

Any help gratefully received

Thanks

 

[Matt Allington]

You are not using DATESYTD correctly. You need to use a calendar table and there should be no reason to use ALL(). Also make sure you mark the calendar table as a date table.