historicize values on a new table

[nannimora]

Hallo everyone,

i vould like to save some data frome one table to another one and saving the data.

I'll try to explain myself better.

i have this data:

Class	Value
0	€ XXXXXX
1	€ XXXXXX
2	€ XXXXXX
3	€ XXXXXX
4	€ XXXXXX
5	€ XXXXXX
6	€ XXXXXX
7	€ XXXXXX
8	€ XXXXXX

And i would like to save this data weekly.

Class	Value	date
0	€ XXXXXX	13/11/2019
1	€ XXXXXX	13/11/2019
2	€ XXXXXX	13/11/2019
3	€ XXXXXX	13/11/2019
4	€ XXXXXX	13/11/2019
5	€ XXXXXX	13/11/2019
6	€ XXXXXX	13/11/2019
7	€ XXXXXX	13/11/2019
8	€ XXXXXX	13/11/2019
0	€ YYYYYY	20/11/2019
1	€ YYYYYY	20/11/2019
2	€ YYYYYY	20/11/2019
3	€ YYYYYY	20/11/2019
4	€ YYYYYY	20/11/2019
5	€ YYYYYY	20/11/2019
6	€ YYYYYY	20/11/2019
7	€ YYYYYY	20/11/2019
8	€ YYYYYY	20/11/2019

I Would like with some query to execute this every week. and add new rows

it is possible in powerbi?

Thank You So Much

G

[Icey]

Hi @nannimora ,

If your data sources are Excel Files, you can refer to this video:

Excel Power Query #06: Import Multiple Excel Files From Folder Into One Excel Table or Data Model.

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.