Forum Discussion
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...
v-cherch-msft
Microsoft Employee
Microsoft EmployeeHi Anonymous
You may check the steps in query editor. Attached the file for reference.
Regards,
Cherie
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
Hi 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