Forum Discussion
Anonymous
7 years agoNot applicable
Load/Pick current week data from Excel
Hi All, Iam new to Power BI and Loading data from excel into Power BI.I have data week wise(53 weeks) ,users provide data on weekly basis ,i want to load only previous week data into Power bi.How to...
Anonymous
7 years agoNot applicable
Hi Cherie,
Thanks for your time.Every week in my source excel file data will get added ,so i have to write automated logic to pic last week numers into Power BI report.
Thanks,
Joshi
v-cherch-msft
Microsoft Employee
7 years agoHi Anonymous
You may try to add a date filter like below post.
https://community.powerbi.com/t5/Desktop/Get-data-for-1-week-before-depend-on-TODAY/td-p/102047
Regards,
Cherie