Forum Discussion
Capture Weekly report (Last week and This Week)
Dear
I have page that contains upto 15 visual and data souce have excel file(upto 50 column and no date column), updation of excel file like adding new row or updating data to existing cells on weekly basis
and report like: for this week:
and for last week:
i did it by change manually the data souce(data source: last week and this week)
Actually i am looking for dynamic like how can i capture complete report for this week and last week and difference between these count and progress
is there any idea to short this issue
2 Replies
Anonymous , does the column have for each week, then you need to unpivot
If they snapshot then you need think about DAX append
https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-data-to-it-using-incremental-refresh/
https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/Once you have week wise data
Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.HI Anonymous,
AFAIK, current power bi does not support cache the historical data.
For this scenario, I think you may need to use a temporary database to import the history records and remark the input date. (check the id or other unique value field in your sheet and compare with existing DB records to remark the input date) After these steps, you can simply use power bi to get data from that database and design visualization reports.
Regards,
Xiaoxin Sheng
