Graph Over time - Changing Values

[areias_br]

Hi,

1. I have a report that is weekly updated. This report contains the data of expired overdues, based on a collum called "Status". So if a row has the Status Overdue then it counts 1.

2. This status however changes over time and has 4 options: Open, Open Overdued, Closed, Closed Overdued (if it was closed after being overdued).

3. I need a graph that shows me if I'm having more overdues this week than last week, and the previous one etc.  So It must show the ammount of overdues in Week 1, Week 2, Week 3 etc. 

My doubt is, how can I do it if the status is always changing? I also have the date when the status changed in a collumm "Conclusion Date". 

[amitchandak]

@areias_br , I think you need to create a snapshot

check if DAX append method can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[areias_br]

Hi Amit,

Thanks for your solution. I'm still trying to find another one as the information is still in the database, I just still don't know to use the proper formulas to get the result I want.

I have collums called "Opening Date" / "Expiracy Date" / "Closing Date" and by verifying these parameters I can say if in a wanted date what was the status of that action.

So...
If Opening Date < Wanted Date AND Closing Date = BLANK() AND Expiracy Date < Wanted Date Then Action is Overdue...

Just need to learn how to make a graph of this...day by day.