Forum

Hi Jacek, Every listobject has that property , you cannot make changes to programming language itself to add more properties and methods. Can yo...

after you get the list of files in that folder, add a new column with the formula: =Excel.Workbook([Content]) Then you will expand this new colu...

It's not right Chris. Use a query from File> From Folder, not a query from excel file for each file in a folder. whenever a new file is added...

Hi Christina, In Monthly_Performance_View!C34 you have text, and in "Monthly_Performance_Data" sheet you have dates formatted to be displayed as "m...

Hi, You can try the code from this resource:

Indeed, this happens frequently when adding custom M code. There are many things that can prevent query folding, you can read more on web about thi...

Hi Martin, There is nothing wrong with your version, you have the latest version and more, it's an office insider version. Try the attached file...

Hi Jim/Brent, You should have a table with 1 column and 1 row, the table name will be SourceFolder: Source Folder E:Dropbox Th...

Hi Martin, I tested 2 more alternatives for you, after splitting the description into words (split by space). One using List.PositionOfAny to id...

Please take a look at this similar forum topic: It's very easy to update to your situation, you can make it case sensitive or not, many alternatives...

Hi Martin, You don't have to upload company data, but I'm sure you can prepare a file with sample lookup tables, sample data table and an example o...

Or, you can manually edit the formula: = Table.Sort(#"Filtered Rows",{{"JOCKEY", Order.Ascending}}) will be: = Table.Sort(#"Filtered Rows",{{"JO...

Hi Rajeev, When dropbox is installed, a json file is created in AppData folder, you can extract the dropbox path from that file using a simple code...

I really cannot see the problem you see. You just have to rename the columns that have the same data before append, the append will work. Provide s...

There is no UI ranking, but you can try this: Sort 2017 column Descending, then add an index column, this index will be your 2017 ranking. Do the s...