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.
64 Comments
- It seems a no-brainer to have this capability, and is so weird that it appears that it doesn't (I've been trying to find a way of doing it for a bit now!). If DAX could have UDFs, it would be possible to start to build a library of data analysis functions that could rival R for data science applications. But without this expandability, it is not in as competitive of a position.
- Yes, we absolutely need this.
- UDF is a basic concept of any programming language
- Completely agree. This would save so much development effort!!!
- Agree ! basic and super powerful. PBI TEAM - pls. add this
- Somewhat flabbergasted that this doesn't appear to be supported.
- Yes that is required
- Code reuse is basic
- Copy-paste waste my time and it's hard to maintain a bunch of duplicate dax code.
- Yes to this. Huge issue on large models with many similar complex measures
