Forum Discussion

Akshay123's avatar
Akshay123
Helper I
2 years ago

Maintain Historic Data

Hi Experts,   I have two excel files, one is with current week data and other Historical data. Every Friday I used to update current week file data and will copy the last week data and update it t...
Need Help
Akshay123's avatar
Akshay123
Helper I
2 years ago

Hi audreygerred 
Thanks for your response!
Requirement is to show current week data in one page and Historic data in 2nd page in Power BI

audreygerred's avatar
audreygerred
Super User
2 years ago

Hi! You could achieve that by setting relative date filters on the 'filters on this page' section of the filter pane (assuming your files have some sort of date field).

  • Akshay123's avatar
    Akshay123
    Helper I
    2 years ago

    Every week I need to do that manually in desktop level. Once the current week file data updated & symentic model refreshes all the changes should happen.