Forum

Hi Aye, You can use Power Query for this. See example file attached (note: I deleted quite a few rows as there were way more than enough examples)....

So pleased to hear that, Bax! Happy holidays to you too! May 2021 be happy and healthy for all.

Hi and welcome to our forum! Your file didn't get attached. Please try again and be sure to click the 'Start Upload' button after selecting your fi...

Hi MG, These sentences: "What makes me confused is that when I drag any item from a table to canvas and drag another item from another table I f...

You're welcome! You can add a photo by clicking on the 'member' icon above your name. Then edit profile > edit avatar. Mynda

Hi Robb, The example file you attached above uses the built in combine files function. The technique I linked to above works slightly differently a...

No worries, you're welcome 🙂

Hi MG, Yes, you can do this with Excel files saved on your PC or a network server in the same way. i.e. Get Files > From Folder > browser to ...

Hi MG, Firstly, your data isn't structured correctly. The MobileWallets table isn't in a tabular format. You also need dimension tables in order to...

Hi Robb, Have you tried to use this technique to get multiple files from a folder that contain multiple sheets with Power Query? Mynda

Hi Bax, You can use the get multiple files containing multiple sheets with Power Query technique to get the unstructured data. Then add a custom...

Hi Kaspars, It appears to work fine for me. However, there's only one value that's different and that's on October 26 for the Minutes past target c...

Hi Erica, I presume you mean Power Pivot, not Power Query, as it's Power Pivot where you create the relationships. Power Query is simply the gettin...

Hi Jerry, That's an interesting concept and solution. Thanks for sharing! Mynda

Hi Steve, In the attached file I used the technique described in this post (see Complex Table example) to reference the next row to determine wheth...