Forum Discussion

nannimora's avatar
nannimora
Icon for Helper I rankHelper I
6 years ago

historicize values on a new table

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:

 

ClassValue
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.

ClassValuedate
0€ XXXXXX13/11/2019
1€ XXXXXX13/11/2019
2€ XXXXXX13/11/2019
3€ XXXXXX13/11/2019
4€ XXXXXX13/11/2019
5€ XXXXXX13/11/2019
6€ XXXXXX13/11/2019
7€ XXXXXX13/11/2019
8€ XXXXXX13/11/2019
0€ YYYYYY20/11/2019
1€ YYYYYY20/11/2019
2€ YYYYYY20/11/2019
3€ YYYYYY20/11/2019
4€ YYYYYY20/11/2019
5€ YYYYYY20/11/2019
6€ YYYYYY20/11/2019
7€ YYYYYY20/11/2019
8€ YYYYYY20/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