Build a history table

[BieBel]

I use a ticketing system and would like to calculate the running number of days that a ticket is ‘open’.

I think I might use the DATASET_DELIVERY_DATE to build a ‘history’ table?

If I run my import on different days, I should get different lines in my table with the fields ID, REQUEST_DATE, STATUS and DATASET_DELIVERY_DATE

How can I automate the aggregation of the different imports in 1 table?

I found an earlier topic on the forum, solved by supruser ImkeF but I was not able to use it for my case/purpose.

 

[danextian]

Does your rawdata have the historical progressions of each id? What is your data source?

[BieBel]

Hello,

My datasource shows only the most recent/the actual status, 1 line per id. It is a table from an Oracle database. That is why I was looking at creating different/multiple lines for the same id by using the DATASET_DELIVERY_DATE to create disctinction between the lines (if the status is unchanged)

[danextian]

Power BI doesn't store a historical version of the data source.  That said, the historical version must be stored somewhere else either directly in the database or in daily exports from the database.

[ryan_mayu]

what's the expected output based on the sample data you provided?