Appending Archive with new extracts

[joshua1990]

Hi experts!

We have in our data warehouse a view that is updated once per month with the latest sales data:

Archival Date	Product	Value	Date
2024-January	A	5	01.01.2024

It archives the past month actual sales per SKU.

Now, I have also a table with products that are missing above in the original archive.

I would like to add these products into the table above starting at MIN archival date and ending in the actual archival date. Like if these products were always there.

Unfortunately, this is not possible to be done at the warehouse itself, it needs to get done in PQ.

How would you do that?

[lbendlin]

Unfortunately, this is not possible to be done at the warehouse itself, it needs to get done in PQ.

Power BI has no memory* . You need to manage your snapshots in the upstream system, either inthe warehouse or in a system between the warehouse and Power Query  (raw extracts for example)

* Yes, there is the self referencing option for a semantic model but that has no safety net.