Custom (Reusable) DAX Function

[omaerkhan]

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 seconds between two date-times. This excludes holidays, weekends, and only counts seconds from the start of the work-day, to the end of the work-day. I use this DAX code a lot, for many measures which need to be in "Working Time" (working hours/minutes). I would love to not have to copy-paste a bunch of code into all of my measures, but to be able to create a reusable function instead.

[grandizercoen]

This would be awesome, however, I suspect since no one from the Power BI team or Microsoft has commented, I figure this will never happen. I freaking need it now.

[josin_33]

Yes, please add to Power BI.

[lpperezg87]

Please add User defined functions to Power BI

[ryan_vincent]

Yes please. I currently have dozens of measures that are basically the same thing but pointed at different time windows (since they need to be directly compared). This would be a great add.

[fbcideas_migusr]

Is this something that Calculation Groups would solve (if introduced into Power BI?) https://www.sqlbi.com/articles/introducing-calculation-groups/

[benjamin_wefers]

Would be a great add. Currently having to use the exact same massive formula to generate a custom column for a dozen tables, and if I improve the formula in one of them, I have to re-copy and paste and localize it a dozen times.

[romela7]

Agree, much time can be saved from creating your own functions with parameter passing. DAX is great, make it greater, thanks.

[kimmo_wiltshire]

Yeap..DAX seems very limited without this simple programming feature. I want to cut the typing and make my code more readable

[skymador]

Must have feature. Would be amazing to have the ability to define reusable functions in DAX.

[tbardien1]

I have the exact same problem. I added several columns that calculate hours between 2 dates in DAX. Then was told, after the fact, it needed to exclude weekends and holidays. Now, I can either write a calculated formula in DAX and copy and paste the code everywhere, or I rewrite the whole thing in powerquery(M) and create a custom function and move ALL my columns, and obviously change my formulas from DAX to M. VERY FRUSTATING.