Built-in M functions

You’ve been tasked with creating a query to list all built-in M functions for quick reference. Specifically, to isolate Table functions since a wealth of useful functions can be applied to streamline your team’s busy workload.

You will also need to test out the use of available table max functions to recommend which function will work best.

If you lost progress, load the workbook 3_1_built_in_m_functions.xlsx from the Workbooks folder and launch the Power Query editor.