Forum

Hi Tracy, There is something in the empty cells in your source data value columns (columns 7 onward) that is causing the problem but not showing up...

Hi Denise, Indeed, it's different in Excel 2013! To find the Properties dialog in Excel 2013 go to the Data tab > Connections > select the qu...

Hi Jacek, Please see attached. I think it's time for you to take a Power Query course. These aren't difficult questions and are things you should b...

I suspect it's because 40 queries are referencing SharePoint at the same time. They don't refresh sequentially so either your PC or SharePoint or both...

Sounds like the URL for the SharePoint file might be wrong.

Hi Luna, Yes, it'll be because you have 40 queries, irrespective of the amount of data in the final query. If you don't need to preview all of t...

Hi Jacek, I'm confused. Your source data doesn't have the 'Total Cost per Topology', but it's in your 'Expected Result'. Is there a second source d...

Hi Tracy, In column 7 you have some text 'PlacementMonth'. If you filter that out after the 2nd step, which is Changed Type, then your data will lo...

Hi Jacek, Great to know you're finding the forum helpful. Please find attached. Note: these techniques are all covered in my Power Query course. ...

Hi Jacek, I can't open the revised file. Can you please upload one with a different name to the original. Mynda

Hi Jacek, You can use append and then GroupBy, but you can't have Power Query assume the tier group is BRO for all of server 1 when one of them is ...

Hi Cele, The Excel worksheet only has 1,048,576 rows, so you'd have to load this as a connection only and put it in the Data Model/Power Pivot. ...

Hi Jacek, Welcome to the forum. Thanks for sharing a sample file. Please see attached. Note: since there is no common column between the two tab...

Hi Anne, The Excel file appears to have been removed and the Word document is empty. Can you please try again? Mynda

Hi Gayatri, Try this: =HYPERLINK(IFS(E14="ABC","#'abc!'",E14="mno","#'mno!'",E14="pqr","#'pqr!'"),"NEXT") Mynda