Load/Pick current week data from Excel

Question

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 achieve the same. i have to load "Week ending february 22"data into Power BI.any help would be greatly appreciated.&nbsp;&nbsp;&nbsp;Source File formatOut put format&nbsp;Thanks,Joshi

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
You may check the steps in query editor. Attached the file for reference.
&nbsp;
Regards,
Cherie

anonymous · Answer

Hi&nbsp;Cherie,&nbsp;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.&nbsp;&nbsp;Thanks,Joshi

v-cherch-msft · Answer

Hi&nbsp;Anonymous&nbsp;
&nbsp;
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
&nbsp;
Regards,
Cherie

Forum Discussion

Load/Pick current week data from Excel

3 Replies

Related content

Default a "Between" Date Slicer to Yesterday on load, while allowing users to pick custom date

Excel Subscription

Fabric Warehouse Connection in Excel

Inmport excel file

Fabric Warehouse Semantic Model with Excel Pivot – Recommended Approach for Excel-Centric Reporting?