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...
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.