Forum Discussion
Solved
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...
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.
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.