Fill empty dates with value from enddate

[PowerBiTG]

Hi,

I have projects which have a residual amount that needs to be used before the enddate. So i calculated the amount that has to be spend per month before the enddate. I made a matrix and the result is this:

So in the mond of the enddate of an project u see the amount that's need te be used per month for the rest of the duration of the project.

I would like to fill the empty months with the value of the enddate. In the model i have a relation between enddate and the datetable which is used in de columns of the matrix.

Which DAX formula can help me fill up the empty columns?

[Mariusz]

Hi @PowerBiTG 

Can you provide a data sample?

Many Thanks

Mariusz

[PowerBiTG]

HI @Mariusz,

I have created a test PBIX with my example. I also made a screenshot of the result i would like to get in Excel.

Test PBIX 

If you have further questions let me know!

Thanks in advance!