Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have a dataset of sales data which is automatically refreshed from a backup at 00:30 every morning.
In Power BI I have a table which shows the week to date sales numbers and associated data points. Some of these data points are in advance and so the latest date of the dataset will always be the day of the backup. E.g. Backup on the 3rd Feb 2020 at 00:30, the latest date will be 3rd Feb 2020.
Herein lies the problem, in the Week to Date table when the backup takes place on a Monday. The WTD table will show data for the Week starting on Monday. This means that you never see the complete Weeks data in the WTD table. On a Sunday morning backup, you will see sales data for Mon-Sat and then on a Monday morning backup, you will see the sales data for Monday.
The filter for the table I was using is Top N (1) on the latest date in the dataset. To try to force the WTD table to look at the previous WTD on a Monday. I created a column in the dataset which was date -1. I then replaced the latest date with date-1 in the filter. In the dataset, this now means the latest date on a Monday is the Sunday but the filter doesn't seem to be working.
I can't change the timing of the backup.
Any help would be appreciated.
Hi @PowerBIWhat
First i need to confirm my understanding abount your problem with you:
your data source has a backup time, automatically refresh from Power BI would get this backup time as the lastest time.
for example, today 2020/2/5, it is Wednesday, backup time is 2020/2/5,
after refresh, the lastest time in power bi is 2020/2/5,
then you want a table to show last week data, it is from 2020/1/27-2020/2(Monday-Sunday).
Is my understanding correct?
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
56 | |
56 | |
38 | |
29 |
User | Count |
---|---|
75 | |
62 | |
45 | |
40 | |
39 |