Forum Discussion
Capturing Dynamic Week-over-Week Sales Changes at Line Item Level
Power BI has no memory. Your data must be stored further upstream.
You could consider using snapshots but that would create larger storage demands.
The better solution is to use CDC or other forms of event tracking. In your example you would have a change history table that would mark the event of a line item being rejected at a certain date (ideally also stating the reason). Then you can recalculate the exact status of any order at any point in time, and easily create change charts (Sankey for example).
Power BI has no memory. Your data must be stored further upstream.
You could consider using snapshots but that would create larger storage demands.
The better solution is to use CDC or other forms of event tracking. In your example you would have a change history table that would mark the event of a line item being rejected at a certain date (ideally also stating the reason). Then you can recalculate the exact status of any order at any point in time, and easily create change charts (Sankey for example).