Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I have 2 excel sheets in the same workbook; a live edited sheet and a master sheet. I am looking to update comment history by comparing the live and master file and if they do not match, concatinate together and replace the master comment. Right now I manually have to concatinate in excel then copy and paste to replace the comments for 24,000 rows.
Note: I did try a macro however this is stored on and edited on a sharepoint which does not allow macros unless the file is downloaded
Live file
Invoice # | Comment Date | Comment | Name | Reason |
100525 | 3/30/2023 | Email update from Jim | Sarah | Billing date moved |
100526 | 2/24/2023 | Increase in budget needed | Jim | Waiting on increase |
Master File
Invoice # | Comment Date | Comment | Name | Reason |
100525 | 2/25/2023 | Increase in budget needed | Sarah | Waiting on increase |
100526 | 2/24/2023 | Increase in budget needed | Jim | Waiting on increase |
Master File - result
Invoice # | Comment Date | Comment | Name | Reason |
100525 | 3/30/2023 | [Name] on [Comment Date]; [live comment]; [Live reason] [master comment] | Sarah | Billing date moved |
100526 | 2/24/2023 | Increase in budget needed | Jim | Waiting on increase |
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |