Forum

Hi Glenn, That sample video has also downloadable files, you can download them to see how data is structured. It's hard to tell what's happening...

Hi Bill, You have to change the process: Create a file with queries to extract data from that private folder, that you will have to update from tim...

Add an index column to both tables, and use those columns as the key to append the tables. You will have to use the Group By option, to aggregate data...

Hi Christopher, I'm sure there should be another way to get to your results, it's not a good idea to replicate in PQ what you do in excel, in PQ you h...

Hi Christopher, There are 2 functions for MAX in Power Query: List.Max and Table.Max. Are you trying to get the Max number from an entire column...

Hi Oleg, The problem is in your function, fnReporting: This custom function is using the Sql.Database function, which has 2 text arguments, and ...

Off-Topic: Hi Frank, I do understand your enthusiasm, but if we want to have a useful forum for our members and visitors, we have to post only o...

First, you have to click the button to "Edit in Browser". The workbook is not in edit mode by default, you have 2 choices: to edit in excel or in brow...

Hi Frank, There is nothing wrong with the file, the slicers are functional, online and offline. Try to repair your office installation, might be...

Happy Holidays Maja 🙂

The latest release was on December 1, here is the article describing the new features added: november-2016-updates-for-power-query/ Another thing y...

Right click the file on onedrive, and select Share.

You mean that you are using 2 versions of Excel? With Office 365, you should be able to upgrade to Office 2016. In Excel 2016, Power Query is updated ...

Hi Maja, There should be no problem importing data from binary workbooks. Which is your version of excel? Try updating excel to install the late...

Hi Nz, Power Query will not write in the source files , that's not possible. What you can do, is to create a new source, other than the 3 existi...