Compare historical information in a schedule

[Taffalaffa]

Hi. I have a table that tracks schedule information of activities for multiple projects.  I need to be able to compare the data to its perevious report date to flag what, if anything has changed.  So for example, I want to compare from the 12/20 data date to the 1/1/23 data date any changes in the activity (task ID is unique).  In the example below I can see that the Activity Name has changed , the OD, and the start and finish dates have changed.  Then from the 1/1/23 data date to the 1/10 data date what has changed? Then from 1/10 to 1/24.... etc.  I only want to compare the information to the next data date.  Guessing I would add a column for each existing column that I want to track and it would be something to the affect of "Activity Name Change since Prev DD" and have it be a "No Change" or "Changed from X to Z" and so on and so forth for the dates, durations, criticality, etc.  I just have no clue how to go about this.  ANy help would be greatly appreciated!  Base excel sheet attached :

 https://www.dropbox.com/scl/fi/4uhsdd9dsr6iuqrxatjrv/Activities-for-Historical-Comparison.xlsx?dl=0&...

[Taffalaffa]

 Hi @onurbmiguel_  thanks for looking at this.  Unfortunately sorting by task ID is not a workable solution.  I have thousands of task ID's in my actual data set.  I need to be able to have an output table of the changes (by type) so for example one table would be all activities that had a name change since the pervious data date, another would be duration changes etc.  I would be filtering the tables by data date so I can see how the information is changing over time.  Any other thoughts?

[onurbmiguel_ · Accepted solution]

Hello 

on the model that i have share you have one measure for each type of change: 

i have made some modification on the pages, please see: 

example.pbix

Best regards

Bruno Costa | Solution Supplier

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal 

[onurbmiguel_]

Hello 

Please see my suggetion for your case.

example.pbix

You will need to filter by task ID: 

Any question please ask 

Best regards

Bruno Costa | Solution Supplier

Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

Take a look at the blog: PBI Portugal