Forum Discussion
Adding Newer Data to Already Built Report
HI Anonymous,
Did you mean your table stored multiple date fields that will be updated weekly?
If that is the case, I'd like to suggest you save these weekly files in the same folder to use the folder connector to get data.Power Query Folder connector - Power Query | Microsoft Docs
Then you can add a custom column and nested 'unpivot columns' function to extract and convert these date fields to attribute(date) and value(status) to simply merge multiple files.
Unpivot columns - Power Query | Microsoft Docs
Regards,Xiaoxin Sheng
| 14/01/2022 | 15/01/2022 | 16/01/2022 | 17/01/2022 | 18/01/2022 | 19/01/2022 | 20/01/2022 | |
| 3 | Success | Success | Success | Success | Success | Success | Success |
| 55 | Success | Success | Success | Success | Success | Warning | Success |
| 13 | Success | Success | Success | Success | Success | Success | Success |
| 7 | Success | Success | Success | Success | Success | Success | - |
| 4 | Success | Success | Success | Success | Success | Success | - |
| 54 | Success | Success | Failed | Success | Success | Success | Success |
Lets say this is the set of data for this week and then the next set of data from the 21st - 27th was a success with no fails or warnings.
HI Anonymous,
Did you mean your table stored multiple date fields that will be updated weekly?
If that is the case, I'd like to suggest you save these weekly files in the same folder to use the folder connector to get data.
Power Query Folder connector - Power Query | Microsoft Docs
Then you can add a custom column and nested 'unpivot columns' function to extract and convert these date fields to attribute(date) and value(status) to simply merge multiple files.
Unpivot columns - Power Query | Microsoft Docs
Regards,
Xiaoxin Sheng