Capture/store the historic timeline data

[schoden]

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]

Hi 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  😃

[v-xiaoyan-msft]

Hi@schoden，

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 Yan

[amitchandak]

@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-...
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

[schoden]

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 

[amitchandak · Accepted solution]

@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]) ))