Capture Weekly report (Last week and This Week)

[Anonymous]

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

[Anonymous]

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

[amitchandak]

@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=pnAesWxYgJ8

If this does not help
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.