Forum Discussion
Skilled SharerHow to proper design a weekly report
Yes, I have tested it, if the data on the file is
111 a 3 20
222 b 3 40
222 e 3 40
333 c 5 70
444 f 10 100Then you will not get the row after refersh.
222 b 6 80Regards,
Charlie Liao
Community ChampionIf you put the file in the same place using the same name you should just need to refresh the data.
- gpiero
Thank you very much for your reply.
Pheraps I am a bit confusing. Up to now I have made reports where the total number of rows always increases.
In this case each week I get a sort of "picture" take in that moment.
My doubt is the following. Let us suppose that in th week 1 we have
Material Project
- gpiero
sorry ... early click...
Thank you very much for your reply.
Pheraps I am a bit confusing. Up to now I have made reports where the total number of rows always increases.
In this case each week I get a sort of "picture" take in that moment.
My doubt is the following. Let us suppose that in th week 1 we have:
Material Project qty value
111 a 3 20
222 b 6 80
333 c 5 70
Then in the week 2 we have:
Material Project qty value
111 a 3 20
222 b 3 40
222 e 3 40
333 c 5 70
444 f 10 100
The row 444 wil be added since it is new. Same happen for row 222 e.
Row 222 b should be refreshed too. But what about the original row:
222 b 6 80
will be canceled from the model?
This is the point not clear to me.
- kcantor
As long as the data exists in your new file it should exist in the query.
It is also possible to add multiple csv files and have the query append the new ones. See here for that: http://www.dutchdatadude.com/combining-text-csv-files-using-power-query-for-excel/
