Power Query M language

• Conditions in Power Query M language
• Custom function basic syntax in M language (Power Query)
• Excel, which downloads and merges all data from the specified folder
• Keep sorted table for Group By, using Table.Buffer
• List.Accumulate and column calculations
• List.Transform – converts list items
• Merging of all columns in Power Query – regardless of their names
• Merging of two ROWs in Power Query
• Power Query – how to find a nth smallest or largest value in table or group
• Power Query and referencing sheet with variable name
• Rename of first (or n-th) column in Power Query
• Running totals in Power Query, using the List.Range function
• The List.Range function, extracting values from specified rows in a column
• The Table.ColumnNames function and its practical use
• Value from Excel cell directly to Power Query