Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Thanks,
Joshi
Hi @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
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