Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
PowerBiTG
Frequent Visitor

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.

Community 1.PNG
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?

2 REPLIES 2
Mariusz
Community Champion
Community Champion

Hi @PowerBiTG 

 

Can you provide a data sample?

 

Many Thanks

Mariusz

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors