Forum Discussion
JP007
3 years agoNew Member
Need help to get lastnonblank value
Hi all, looking for some help here... i just can't figure it out. I need to show the total for days that I don't have a value using the last available balance. i.e. January 3 should be showing m...
Ahmedx
Super User
3 years agowatch this video
https://www.sqlbi.com/tv/consecutive-days-with-no-sales-unplugged-18/
https://www.sqlbi.com/tv/counting-consecutive-days-with-sales-unplugged-47/
And
https://community.powerbi.com/t5/Desktop/How-to-count-empty-cells-in-one-to-many-relationship/m-p/3085858#M1047092