Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |