Query parameters are, in my opinion, one of the most important features added to Power BI recently. The official blog post describing how to use them is great (read it if you haven’t done so already) ...

To use this new function create a new query from the table InputNumbers1 (shown above) using the From Table button. Then in the Edit Query dialog create a new step by selecting Insert Column/Custom: ...

Please contribute in the folder category that best suits. If the folder does not exist, create it. The functions you create will only work if all the Power Query native functions used are declared in ...

Create a blank query in Power Query. Power Query will open the formula bar and name the query Query1, which you can change to Commission Rates. Simply double-click the name and enter the new name ...

Custom functions in Power Query are invaluable for repetitive tasks, ... Apply Custom Functions: Create and store reusable custom functions, such as removing null columns, ...