•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Automatic sorting of table before refresh PQ
Our take
Managing a dynamic to-do list in Power Query can be challenging, especially when new tasks are added to your master list. To ensure that your task markings and comments remain intact during updates, it's essential to sort your table correctly before refreshing the query. By implementing an automatic sorting mechanism, you can maintain the integrity of your list while allowing users the flexibility to filter and sort as needed. This approach empowers your team to stay organized and focused on completing their tasks efficiently.
Hi.
I am using Power Query to make a to do list.
I am having a master list with the deadlines (monthly/weekly). This master is unpivoted to create the to do list. Unique id for each task would be ID + week.
People are allowed and should filter and sort the list as they please. When a job is done they will mark it done (check box).
But sometimes there will be new tasks in the master and the query needs to be updated. The sorting will make the markings and comments jump so I will need to make sure it is sorted correctly before updating.
Is there a good way to this. I have tried the copilot, but it was not to much help…
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#rows.com#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#financial modeling with spreadsheets#Excel alternatives#Power Query#to do list#master list#tasks#sorting#deadlines#filter#sort#unpivoted#unique id#update query#refresh#sorting before updating