Forum

Hi Vanessa, Power Query doesn't have this option, but you can join the columns back together using Merge Columns and set the delimiter to a comma. ...

Hi Leah, Thanks for sharing your sample file. This is actually a great question and I have a solution for you in the attached file, but you need to...

Hi Anne, Thanks for the file, however the problematic columns are formulas that don't evaluate unless I have access to the file Netfort_12.xlsx. Ar...

Awesome, James! Great to hear you've had so much success with Power Query. Keep spreading the word 🙂

Hi Alex, Your example file has 2 items in left table and 1 item in right table. The result when you don't group the tables prior to merging is what...

Hi Tykru, I suspect your home version of Excel needs updating. While both PCs have Excel 2016, they could be different builds with different functi...

Hi Ramki, I don't know of a way to make a Gantt chart from a PivotTable but these tutorials may help: Mynda

Hi Anne, That looks like the Power Pivot screenshot. I need to see the Power Query view. After seeing your formula I think I need to see everything...

Hi Anne, To be clear, you don't need to create the data model first, just load your query to the data model and it adds a sheet/table for your quer...

Hi Anne, Not without seeing what it looks like in Power Query. Can you share screenshots of the Power Query editor view, including the formula/M co...

Hi Anne, Create the query as a connection only. If you have Excel 2013 or 2016 you can Close and Load to > Connection Only and check the box to ...

You can edit the file path directly in the Advanced Editor. The Advanced Editor is accessed via the Home tab of the Power Query editor window. Have yo...

No idea, sorry. Have you checked the file path hasn't changed? Have you tried copying the M code from the advanced editor and pasting it into a new bl...

Great! I figured you meant Excel.CurrentWorkbook() 😉 Mynda

Hi Mark, I'm having a hard time picturing your file set up in regards to these 'custom reports' and how you want to use them for the mid-month pro...