Hello @KEO46 Yes, you can achieve this in Power BI by using Power Query to import the Excel spreadsheet containing the daily table data and then comparing the current load to the previous load for any changes. Here’s a general approach:
1. Import Excel Spreadsheet: Use Power Query to import the Excel spreadsheet into Power BI Desktop. You can schedule this import to occur daily using the “Get Data” feature in Power BI.
2. Transform Data: In Power Query Editor, transform the data as needed, ensuring that each daily load creates a new set of rows in your table.
3. Create Key: Generate a unique key for each row in your table to facilitate comparison between the current and previous loads. This key could be based on a combination of relevant columns in your data.
4. Load Data: Load the transformed data into Power BI Desktop.
5. Create Comparison: Use DAX (Data Analysis Expressions) in Power BI to compare the current load to the previous load based on the generated key. You can create measures or calculated columns to identify changes, additions, or deletions between the two loads.
6. Visualize Changes: Create visualizations in Power BI to present the comparison results, such as tables, charts, or conditional formatting to highlight changes.
If I have answered your question, please mark your post as Solved. If you like my response, please give it a Thumbs Up. Also, how are you doing today? Remember, every challenge is an opportunity for growth.
