SnapShot of Table

[tjeffries]

All 

I am stuck and would be grateful for any help.

I have two tables that only have 4 weeks of data at a time. 

They both refresh every week and the oldest week's information is deleted.

I need to create a historical table with the shipment and order value information that will add the new week's information to it and not be affected by the weekly refresh.

Report date  Order  Product color
1-Aug           1            red
7-Aug           2            blue
13-Aug         3            white
15-Aug         4            black
16-Aug         5            yellow

Order    Order Value
1               $6.50
2                $7.50
3                $8.50
4                 $9.75
5                $10.00

Thanks in advance

-tj

[amitchandak · Accepted solution]

@tjeffries , refer if this can help

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

[tjeffries]

thank helped 🙂 Thank you!

[v-diye-msft]

Hi @tjeffries 

If the above posts help, please kindly mark it as a answer to help others find it more quickly. thanks!

If not, please kindly elaborate more.