Forum Discussion
CTodd
Feb 11, 2025Copper Contributor
Excel filters with live and non-live data
Hi, I have created a spreadsheet for our attendance tracking. The spreadsheet contains some live student and attendance data pulled from our MIS, alongside non-live columns containing weekly comm...
- Feb 11, 2025
My guess live data returned to the grid by Power Query and non-live data is added manually to next columns. If so yes, they exist independently.
Workaround is to use self-referencing query as explained here Self Referencing Tables in Power Query 🔗- Excelerator BI, other words you need to modify main query accordingly.
SergeiBaklan
Feb 11, 2025Diamond Contributor
My guess live data returned to the grid by Power Query and non-live data is added manually to next columns. If so yes, they exist independently.
Workaround is to use self-referencing query as explained here Self Referencing Tables in Power Query 🔗- Excelerator BI, other words you need to modify main query accordingly.