cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
souchock
Regular Visitor

Copy newly added data to fixed column

Hello,

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. 

souchock_2-1597086737581.png

 

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.

souchock_3-1597086753283.png

souchock_4-1597086804484.png

Is there a Dax operation to do this ?

 

Thanks

 

 

6 REPLIES 6
v-xicai
Community Support
Community Support

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.

 

Best regards

Amy

v-xicai
Community Support
Community Support

Hi @souchock ,

 

You may refer to the links:

 

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

 

https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/

 

http://excel-inside.pro/blog/2019/03/21/classical-incremental-refresh-for-cloud-data-sources-in-powe...

 

Best Regards,

Amy 

 

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.

vanessafvg
Super User I
Super User I

there is also incremental refeshes if you have premium https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh which might solve your issue

https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Thanks.

 

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)

you will have to keep history if you using the same source and overwriting it. Or create a new field for the original date.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




vanessafvg
Super User I
Super User I

power bi isn't a database as such, you will need to store historic copies of your data if you want retain history.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 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.