User Defined Functions (UDFs) are, in my opinion, the biggest update to Power BI Desktop since PBIP.
That may sound dramatic, but if you care about DataOps, semantic model quality, and reusable development patterns, UDFs fundamentally change what is possible with DAX.
Reuse is one of the core principles of DataOps. For years we have been able to build reusable patterns in Power Query, PowerShell, Python, YAML, and infrastructure automation. But DAX was always missing a key capability: reusable logic that could live inside the semantic model itself.
Until now.
Read on to learn more, as well as to get a link to John’s PQL.Assert DAX unit testing library.