I have used a lot of time in the Power Query Formula specification help on the web – and several time for the same function – so I ended up switching between browser and Power BI Desktop.
Then I recalled reading this blogpost – http://www.excelguru.ca/blog/2015/05/13/what-power-query-functions-exist/ and decided to put the help directly in as a Query in the “Edit Queries” window.
Now I can filter the functions by name and/or when I click the “Function” in the Value column – I get the help about the function below.
The steps to create your own table is like this
And for you to copy
Source = #shared,
#”Converted to Table” = Record.ToTable(Source)
#”Converted to Table”
Hope this can help you as well.