Forum Discussion
Build a history table
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.
4 Replies
what's the expected output based on the sample data you provided?
Does your rawdata have the historical progressions of each id? What is your data source?
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)
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.
