Creating a reusable custom function allows for consistent, scalable, and time-efficient application of the null column removal process across multiple datasets.

Custom functions created in Power Query can be made reusable across multiple workbooks by storing them in a personal macro workbook using VBA.

Among the new features is support for Azure Machine Learning and custom JavaScript functions to Excel to extend its capabilities. Excel now also allows Power BI developers to bring the custom ...