Forum Discussion
nannimora
Helper I
6 years agohistoricize 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:
| 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
1 Reply
- Icey
Community Support
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.