Forum Discussion

PowerBIWhat's avatar
PowerBIWhat
Icon for Helper I rankHelper I
6 years ago

Week to Date - date filtering

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 ...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

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.