Forum

Hi Aye, There's no automatic page numbering like we have in Word or Excel, but this post describes a way to do it with bookmarks. Mynda

Hi Ken, There's not really an elegant way to do this because the names are not consistently formatted. See attached. Mynda

Hi John, Welcome to the forum. We use the COLUMN function to generate an array of values, in your case this COLUMN($A$2:$K$2) generates 1 throug...

Hi MD, Your question isn't clear, which is probably why no one has answered it yet. I presume the 'table' you're referring to is the one on the ...

Hi Aye, You can set the visual level filter on each chart to a specific region, then you don't need the Region Slicer at all. That said, I sugge...

Glad you found a solution. I wouldn't worry about having a load of steps to get to the end result. It often doesn't make the query any less efficient ...

Hi Mustafa, Welcome to our forum. You'll see in the attached file that I've used Transpose so the first two rows can be merged. Then you can Tra...

In theory yes, but I haven't seen your data so it's difficult to be specific. Assuming the new data has a column header that is today's date, or at...

Hi Tracy, Firstly, the 'sample queries' and other queries in the 'Transform File from Data' query folder are automatically generated when you use '...

Hi Felix, Welcome to the forum. I'm not sure what you mean by 'remove the summation sign'. The sigma sign indicates that the field is a value th...

Hi Jim, Please see attached. Mynda

Hi Andrea, In session 3.01 I show you how to do this. Create a blank query. In the formula bar type =Excel.CurrentWorkbook() and press ENTER. ...

Hi Aye, The process is the same irrespective of how many facilities you have or whether the data comes from Access or the sample in the Excel file ...

Hi Aye, Please upload an Excel file containing a sample of your data with enough examples that cover every scenario, and show the desired result of...

Hi Tracy, Thanks for filling in the blanks. I understand now. For Power Query to get updates the workbook containing the source data must be clo...