Forum

Hi Kevin, If you prefer, you can use STOCKHISTORY to get the close and you can calculate the change and change % by getting the close from the prev...

Welcome to our forum! It's best not to add formulas to tables that are the output of queries as there's no guarantee they'll stay in alignment. Ple...

Hi Kevin, When you provide Power Query with a URL to get data from, it will present you a list of the tables on that page from which you can choose...

Hi Bruno, You can create a blank query with this code from ExcelGuru.ca: let Source = #table(type table[LastRefresh=datetime], {{DateTime.Local...

Hi Michael, Unfortunately, this is by design. Mynda

Hi Jen, Open the query in the Query Editor and change the name in the properties pane on the right hand side. Note: this will break any PivotTables c...

Hi Sadik, Thanks for sharing your file. It's not clear what you want to change these values to and if there is a pattern Power Query can follow. Ad...

Thanks for sharing, Dave!

Hi Bryce, Welcome to our forum! I wonder if you've seen how you can use Power Query to automate getting data from a website. It doesn't work wit...

Hi Sadik, Welcome to our forum! Your file isn't attached. You need to click the 'start upload' button after selecting your file. Mynda

Hi Charles, Welcome to our forum! I think you're on the right track to use Power Query to fill up/down. Hopefully this example of a Gantt chart ...

Hi Fausto, It's not clear if the data in the 6 separate PivotTables comes from the same source data or 6 different sources? If it's coming from a s...

Hi Mark, The short answer is no. The chart only reads the data you give it, it cannot then export data itself. However, since the chart is referenc...

Hi Marciano, I selected a cell in the PQ editor window containing one of the A letters, then in the bottom you get a preview of that cell and can c...

Hi Marciano, Thanks for sharing the correct file. The Build Summary table has spaces after the As in the Creation Prod column. Select this colum...