I'd like to be able to create reusable functions in DAX, instead of using the same DAX code in multiple measures. Example: I have some complicated DAX code, which calculates the no of working second...
I am fairly new to Power BI and DAX (less than 3 years) but over 40 years programming in C, C#, C++, etc. I am used to having UDFs to reduce code duplication but in my latest DAX endeavor, I was faced with having to generate a dynamic DAX table (based on a user specified Fiscal Year) and returning 2 or 2 columns from the resulting table. The problem is that I cannot return a record from a measure and thereby forced to replicate the measure for each of the desired columns. If that's the case, having a UDF one could encapsulate the creation of the dynamic table and having as an argument the column to be returned. If an update is necessary, the developer will only need to modify the UDF rather than every measure that has the same logic.
