I have a monthly extract with a report with projects that have 50 columns. Each column represents information that may change next month. Next month I get the same type of report which may have:
- new projects
- some records under any of the 50 columns may have changed
Is there a report I can run to come up with what has changed during the month, i.e. 1) which project numbers were added and 2) for existing projects: which records have changed under any of the 50 columns
I have been trying to think what is the best way to do it. I thought to use Power Query but so far it is becoming a long exerices because I have been using boolean logic to compare each column of current month and previous months report. But it is a quite long exercise. Thank you all in advance for any tips you may have
- new projects
- some records under any of the 50 columns may have changed
Is there a report I can run to come up with what has changed during the month, i.e. 1) which project numbers were added and 2) for existing projects: which records have changed under any of the 50 columns
I have been trying to think what is the best way to do it. I thought to use Power Query but so far it is becoming a long exerices because I have been using boolean logic to compare each column of current month and previous months report. But it is a quite long exercise. Thank you all in advance for any tips you may have