Forum Discussion
Capture/store the historic timeline data
Hi Community,
Is there a way I can capture and show historic data in some point of time.
My data refreshes daily and projects only the latest data.
For instance:
A ticket is created on 15 Feb 2021, on 18 Feb 2021 it is pending and on 20 Feb 2021 its is closed.
However the data now shows as closed on 20 Feb 2021. I want to see the status from creation till closed.
| Ticket | Date | Status |
| A | 15 Feb 2021 | Closed |
| B | 3 March 2020 | Closed |
Would really help me as I have been trying since last one week 😞
Thank you in advance
schoden , Try that Dax append way first, Then you need to check max status before that date.
calculate(lastnonblankvalue(Table[Date], Max(Table[Status])), filter(all(Table), Table[ticket] = max(Table[tickte]) && Table[Date] <= max(Table[Date]) ))
5 Replies
schoden , I do not see any data for creation.
1. Data is getting overwritten and you do not have that. Refer DAX append to snapshot the data first
2. You have not shown an example of data showing an open line. PLease share data in that case
Check DAX append
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/Yes the data gets overwritten in the status field.
Status have value (bascially all those values projects at a point of time )
1. Created
2. Pending
3.Closed
4. Rejected
schoden , Try that Dax append way first, Then you need to check max status before that date.
calculate(lastnonblankvalue(Table[Date], Max(Table[Status])), filter(all(Table), Table[ticket] = max(Table[tickte]) && Table[Date] <= max(Table[Date]) ))
Hischoden，
It's pleasant if your problem has been solved, could you please mark the reply as Answered? that way, other community members will easily find the solution when they get the same issue.
Hope it helps.
Best Regards,
Caitlyn YanHi All ,
I am grarteful for replies/solution given. However one solution worked for me or atleast got me to the closest goal is Incremental refresh using PowerBI pro and Dataflows - Exceed blog by
Krešimir Ledinski . You can find the video
https://www.youtube.com/watch?v=aAzSZbrICxE
Thought I will share in the forum 😃
