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 res...
DAX
empty columns
Mariusz's avatar
Mariusz
Icon for Community Champion rankCommunity 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!