Load/Pick current week data from Excel

[Anonymous]

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.

Source File formatOut put format

Thanks,

Joshi

[v-cherch-msft]

Hi @Anonymous 

You may check the steps in query editor. Attached the file for reference.

Regards,

Cherie

[Anonymous]

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