Store the daily live date into a table

[TomLU123]

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!

[v-yulgu-msft · Accepted solution]

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

Report history - snapshots. Like in SSRS you can snapshot on schedule. Ability to replay some visual...

Best regards,

Yuliana Gu