I’m trying to find a way to visualize item [Unit Cost] trough time. In order to do so effectively I would need to be able to show a value for every single day since the item first had a [Unit Cost] Value <> 0,00 before that time it should return a BLANK.
After that first time - on all dates the [Unit Cost] didn’t change I want to show the last known [Unit Cost] Value <>0. So if a change resulted in a Value =0 then I want to show the last known [Unit Cost] Value <>0 before that.
I’ve worked out what the previous date was where the [Unit Cost] <>0. But so far that didn’t get me anywhere… Any help will be much appriciated!
Attached the PBX-file Track Unit Cost trough time.pbix (159.5 KB)
Below an image of what I hope to achieve in Power BI