It is easy to develop function inside PowerBI. To reuse your code; or execute logic at a row basis. It becomes harder when you are developing and changing functions with parameters. That’s mainly because you cannot step through a function line by line and see the intermediate results. With this little trick, you can easilyRead more about Developing Power BI functions with arguments[…]
I started researching this question when I came at a great post of Rick de Groot at ExcelGorilla. So instead of posting, here is the link: How to Group By Maximum Value using Table.Max – Power Query #3
Background Sometimes the performance of Power Query reading your source data is restricting your dashboard development.It takes too long to reload all your data.I Recently had a case where my source was a set of log files on an Azure Blob. While developing the dashboard I often times had a very bad internet connection. ThisRead more about Development vs Production (Data Source Filtering)[…]