cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vozniak
Helper I
Helper I

tracking different versions of the same data

We are looking at a comparison of planned activtiy month over month and year to year that changes with each version of the plan. We need to be able to show the current version of the data against the previous version of the plan. Right now, we copy the data into a table showing the date of the plan update and then pull from that table. Is there anyway to automate the process so we don't have to manually pull the data but can show the most recent plans?

1 REPLY 1
v-yuezhe-msft
Microsoft
Microsoft

@vozniak,

Are you able to export data of different dates into Excel or CSV files?

In your scenario, you can put all excel(or csv) files into a folder, connect to this Folder in Power BI Desktop, create month-to-month and year-to-year measures following the guide in this article, and then publish the report to Power BI Service. In Power BI Service, you are able to set schedule refresh for your dataset, this way, once you add new files into your folder, the dataset and report will be automatically refreshed in Power BI Service.


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.