Speed up Power Query from SharePoint by swapping SharePoint.Files for SharePoint.Contents, cutting refresh from 44.6s to ...
Excel's query tool reshapes messy imports into 1NF, so AVERAGEIFS replaces hacks and your summaries run faster.
Results that may be inaccessible to you are currently showing.
Hide inaccessible results