Forum

Hi Cory, Power Query can push processing back to external databases like SQL etc., which is called query folding. However, as your data is in Excel...

Hi Ileana, I'm a bit confused because you say there are 662k lines in query 1, which I presume is not grouped, but the grouped query 2 has 813k lin...

Great solution, Blanka! I've never noticed the All Rows option in the group dialog. I learnt something new too 🙂 Mynda

Hi Cory, The method you describe in option 3 is what I would do. Less queries or less steps does not always = more efficient. The benefit of usi...

Hi CS, You can add columns to a Query Table that has been loaded into the Excel sheet, but not rows. If you're wanting to add/modify rows then I wo...

Wow, cool trick, Sunny!

Hi Teddy, Anders suggestion is a good one, but you'll need to use Power Pivot to set the Sort By for your column based on an index or ID column. ...

Hi Jace, That's tricky. I created a lookup table for the class order mapping to groups called 'Groups'. Then I unpivoted the original data and merg...

Hi Poonam, Please upload a sample Excel file and provide an example of the end result you're trying to achieve. The screenshot only shows a cell in...

Hi Ashwani, You can use Power Query to get the data from an Excel file saved on Google Drive as described here: Mynda

Awesome! Thanks for sharing, Chris.

Hi Samantha, Best practice is to use Power Query to get your data, clean it and add any calculated columns you need, then load it to Power Pivot. T...

Glad you got there in the end, Chris.

Hi Cory, You can also change the Close and Load settings via the Queries & Connections Pane in Excel. Just right-click the query you want to mo...

Hi Jon, Thanks for sharing your file. I'm a bit confused by the example because PO1 is vacant in September, but Sue isn't terminated until October....