Calculating Changes in Cumulative/Appended Report

[Twizxup]

Hi All,

I receive a report every week that consists of our company's current cost centers and, each week, I append it to the previous week's report. My ultimate goal is to only return a list of changes that have taken place (then/now). Below is a sample dataset of the appended reports (my source data).

Report Date	Cost Center Code	Cost Center Name	Cost Center Division	Cost Center Department	Cost Center Owner
1/1/2025	123	Financial Planning1	Finance	Financial Planning	Janet
1/1/2025	234	Compliance1	Human Resources	Compliance	Ed
1/1/2025	345	Customer Sales Analysis1	Sales	Customer Sales Analysis	Madison
1/1/2025	456	Data Analytics1	Chief Operating Office	Data Analytics	Mitch
1/1/2025	567	Corporate Finance1	Finance	Corporate Finance	Chris
1/8/2025	123	Financial Planning1	Finance	Financial Planning	Janet
1/8/2025	234	Compliance1	Human Resources	Compliance	Ed
1/8/2025	345	Customer Sales Analysis2	Sales	Customer Sales Analysis	Madison
1/8/2025	456	Data Analytics1	Chief Operating Office	Data Analytics	Luka
1/15/2025	123	Financial Planning1	Finance	Financial Planning	Janet
1/15/2025	234	Compliance1	Human Resources	Compliance	Ed
1/15/2025	345	Customer Sales Analysis2	Sales	Customer Sales Analysis	Madison
1/15/2025	456	Data Analytics1	Chief Operating Office	Data Analytics	Luka
1/15/2025	678	Taxes1	Finance	Taxes	Adam

Using this data, I'd like to return a table that captures only the week-to-week changes, including cost centers that have been added or removed. An example of the desired output is below.. please note that the green font represents the values that changed, and the "Explanation" field with orange font is just a helper field to explain what changed (although I also want to create this calculated field, which I believe should be pretty easy).

Cost Center Code	Then/Now	Report Date	Cost Center Name	Cost Center Division	Cost Center Department	Cost Center Owner	Explanation
345	Then	1/1/2025	Customer Sales Analysis1	Sales	Customer Sales Analysis	Madison	Cost Center Name Change
345	Now	1/8/2025	Customer Sales Analysis2	Sales	Customer Sales Analysis	Madison	Cost Center Name Change
456	Then	1/1/2025	Data Analytics1	Chief Operating Office	Data Analytics	Mitch	Cost Center Owner Change
456	Now	1/8/2025	Data Analytics1	Chief Operating Office	Data Analytics	Luka	Cost Center Owner Change
567	Then	1/1/2025	Corporate Finance1	Finance	Corporate Finance	Chris	Cost Center Removed
567	Now	1/8/2025					Cost Center Removed
678	Then	1/8/2025					Cost Center Added
678	Now	1/15/2025	Taxes1	Finance	Taxes	Adam	Cost Center Added

Any help would be hugely appreciated! Thank you in advance!