Forum

Hi Catherine, It's great to hear you're enjoying the course and even better to see you're practicing and trying out your own ideas. You're on the r...

Hi Aye, Please see attached. Mynda

Aw, just glad I can help 🙂

Hi Voigt, Excel doesn't have enough columns for you to format it like this. That said, it sounds like what you need to do is bring in all of the da...

Oh, ok. Originally you said "I have 30 xl files in one folder. Each xl file contains 1 query cold Sales."

Hi Danielle, Create a new query that references the first. Remove everything except the part number and description columns. Since you don't mind w...

Hi Mark, It's odd indeed. Do all other users have access to this drive: "I:UserskolszewskiFiles QA stats" or is it just you? Mynda

Your file won't become 'heavy' because the 30 Excel files will contain one query and one query output into a table in the worksheet. You then get all ...

Hi Bax, This type of analysis is something you do in Power Pivot using the DISTINCTCOUNT function. That said, if you really want to do it with Powe...

Sorry I didn't see that you'd uploaded the file, but I'm glad you found a solution that gets you part of the way. I had a look at your file. It's n...

Hi Thyf, Have you loaded each query output to a worksheet in these 30 Excel files? If so, you can use Get Files > From Folder to get them in a n...

Hi Anupam, As I explained in my reply to your duplicate question on our YouTube channel, in Excel 2013 you have to use a Date/Calendar table to spe...

Hi Mark, Can you please share the M code from all of the queries in the file from the user's PC that is throwing the error showing the U drive file...

Hi Vanessa, Welcome to our forum. Thanks for sharing your file. You'll see in the attached file I've added your ReportOutput data to Power Pivot. I...

Hi Jessica, Custom list sorting requires every PC to have the custom list installed. If you use Power Pivot then you can specify a sort order ba...