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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Need DAX to populate rest of my row

Hi,

 

I have the below DAX: 

 
LastInv =
Calculate(
Sum('Plan PBI_GTS_SIOP_Supply_Demand'[inventory])
, FILTER(KEEPFILTERS('Plan PBI_GTS_SIOP_Supply_Demand')
, 'Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week]=calculate(MAX('Plan PBI_GTS_SIOP_Supply_Demand'[Relative Week]),'Plan PBI_GTS_SIOP_Supply_Demand'[inventory]>0)
)
)
 
I need to add to the DAX to populate the future blank row cells with the previous "LastInv" Number in this case 6.74.
 
Elmo333_0-1642526849933.png

 

I'd appreciate any help thanks,

2 REPLIES 2
ValtteriN
Super User
Super User

Hi,

Here is a thread discussing similar topic. I think it might be of
help: https://community.powerbi.com/t5/Desktop/Dax-Repeat-last-non-empty-measure-for-date-sequence/td-p/62...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

yes definitely some essence of what I'm looking for but was hoping to have some opinions on my current DAX or what's needed to alter it if possibel to achieve my need.

Cheers

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.