Omaer Khan on 01 Mar 2017 02:06:50
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.
- Comments (30)
RE: Custom (Reusable) DAX Function
I would love to have this function, too. Especially around passing arguments to these functions would be "very" helpful and would declutter a lot. Recent example, I had to do the same non-standard comparison calculation for 5 different product brands --> 5 new measures. one functions and 5 ways to define arguments would help.
RE: Custom (Reusable) DAX Function
..tumbleweed... I genuinely wonder what the PowerBi team is working on sometimes when features like this get ignored for years.
RE: Custom (Reusable) DAX Function
Must have feature. Would be amazing to have the ability to define reusable functions in DAX.
RE: Custom (Reusable) DAX Function
Yeap..DAX seems very limited without this simple programming feature.
I want to cut the typing and make my code more readable
RE: Custom (Reusable) DAX Function
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.
RE: Custom (Reusable) DAX Function
Agree, much time can be saved from creating your own functions with parameter passing.
DAX is great, make it greater, thanks.
RE: Custom (Reusable) DAX Function
Is this something that Calculation Groups would solve (if introduced into Power BI?) https://www.sqlbi.com/articles/introducing-calculation-groups/
RE: Custom (Reusable) DAX Function
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.
RE: Custom (Reusable) DAX Function
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.
RE: Custom (Reusable) DAX Function
Please add User defined functions to Power BI