Forum Discussion
BieBel
Helper I
Helper IBuild 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...
danextian
Super User
Super UserDoes your rawdata have the historical progressions of each id? What is your data source?
BieBelHello,
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.