Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Fill empty dates with value from enddate

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?

DAX
empty columns

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    Can you provide a data sample?

     

    Many Thanks

    Mariusz

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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!