Replace blank value by previous values cumul data

[Juju123]

Hi,

I have a table in which I calculated the cumulative quantity in DAX:

Cumul quantity = calculate (SUM('table_fact'[Quantityu]),
DATESYTD('table_calendar'[Date]))

I have a problem that I can't solve, when I have an empty value, I want to replace it with the previous value.

In my example, I have no data after January 2023 so all years after February 2023 will take the previous value, i.e. 5. How can I solve this problem?

THANKS 

[Rupak_bi]

Even if its direct query, the formula should work. In above case the fact table is direct query and date table is static.

[Juju123]

Hi @Rupak_bi , 

ok I try your formula and I get back you say if work or not 

thanks you

[Rupak_bi]

Hope this will work.....

[Juju123]

Hi @Rupak_bi , 

I'm on DirectQuery Mode and your formula doesn't work. 

1. I create a measure which calculate the cumul like this : 

Cumul quantity = calculate (SUM('table_fact'[Quantityu]),
DATESYTD('table_calendar'[Date]))

When i want to use this measure in calculate like your example, it's doesn't work