I want to ask you all about the approach that might work best to compare the current version of a report to a prior version (refreshed data). Basically I just want to see which values in certain columns changed for each row. For instance, for event ID #1, did the meeting time change, did the meeting location change, etc.
Each item has a unique ID number that can be used to easily identify which items are on both reports. I know how to insert the data from the prior report using Index-Match in new columns on my current report, but it seems like PowerQuery does this a bit more efficiently.
From there though, do I have to then create helper columns to compare the prior and current value columns? That is what ChatGPT recommended.
I'd like to avoid having to do the helper columns if possible, but using PQ may have at least let me skip the Index-Match steps. Is there an easier way to approach this? I'm just starting to learn PowerQuery.
Each item has a unique ID number that can be used to easily identify which items are on both reports. I know how to insert the data from the prior report using Index-Match in new columns on my current report, but it seems like PowerQuery does this a bit more efficiently.
From there though, do I have to then create helper columns to compare the prior and current value columns? That is what ChatGPT recommended.
I'd like to avoid having to do the helper columns if possible, but using PQ may have at least let me skip the Index-Match steps. Is there an easier way to approach this? I'm just starting to learn PowerQuery.