I am trying to use powerbi to read excel data from a task schedule. But I would like to use PowerBI to show the original scheduled dates, even after the schedule gets updated.
So when new data is entered in Start Date and End Date, I want columns to be populated with that data.
But once the Original Dates are populated once, I don't want them to ever change again.
So if the Start Date and End Date are adjusted, I want the Original dates to remain static.
Wednesday's new update: Start and End date updated for Task A, but Original didn't change. Now Task B also has newly added dates.
Then on Friday, Task B's dates are adjusted, but the Original dates don't change.
Is there a Dax operation to do this ?
Hi @souchock ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Hi @souchock ,
You may refer to the links:
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Basically what I want to do is create a Baseline data column based on the first date entered for a given row.
(Similar to the MS Project Baseline function)
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.