Forum Discussion
Helper IIIStore the daily live date into a table
Dear experts,
I am building a report to track the live data in "Live Validation Result Table". This table will refresh daily and the previous day's data will be covered by Today's data. I wish to create a "Validation Result History Table" to store the result of each day so that we can track the trend. Is there any way to write some DAX to create the table to store all the live date?
Live Validation Result Table
| Date | Employee ID | Validation Result |
| 8/7/2018 | 42222 | Invalid Gender |
| 8/7/2018 | 42223 | Invalid Gender |
| 8/7/2018 | 42224 | Invalid Gender |
| 8/7/2018 | 42225 | Invalid Location |
| 8/7/2018 | 42226 | Invalid Gender |
Validation Result History Table
| Date | Employee ID | Validation Result |
| 8/7/2018 | 42222 | Invalid Gender |
| 8/7/2018 | 42223 | Invalid Gender |
| 8/7/2018 | 42224 | Invalid Gender |
| 8/7/2018 | 42225 | Invalid Location |
| 8/7/2018 | 42226 | Invalid Gender |
| 8/6/2018 | 42222 | Invalid Gender |
| 8/6/2018 | 42223 | Invalid Gender |
| 8/6/2018 | 42224 | Invalid Gender |
| 8/6/2018 | 42225 | Invalid Gender |
| 8/6/2018 | 42226 | Invalid Gender |
Many thanks!
Hi TomLU123,
What you want is like a feature called "snapshot" that allows to store history data without overwriting old data. However, it is not possible to achieve such a requirement in Power BI now. Here is a similar thread: Create "snapshots" on changing data
As a workaround, you could create table in a DB to run a SSIS append query, simply adding a date field. That table is then used as data source for Power BI report.
Someone has submitted this feature quest at idea page, you can click to vote it up:
Allow for point-in-time snapshots for reports/dataset
Best regards,
Yuliana Gu
1 Reply
v-yulgu-msftMicrosoft Employee
Hi TomLU123,
What you want is like a feature called "snapshot" that allows to store history data without overwriting old data. However, it is not possible to achieve such a requirement in Power BI now. Here is a similar thread: Create "snapshots" on changing data
As a workaround, you could create table in a DB to run a SSIS append query, simply adding a date field. That table is then used as data source for Power BI report.
Someone has submitted this feature quest at idea page, you can click to vote it up:
Allow for point-in-time snapshots for reports/dataset
Best regards,
Yuliana Gu