Forum Discussion
User-defined functions in DAX?
Hi, this is a general question about the DAX language as I can use it in Power BI:
Can I, as a user, define/create/reuse new functions in a Power BI report? I'm often in the situation that parts of several measures could be abstracted into a shared function. This is easy to do in M (Power Query) but I don't see any way to do this in DAX.
7 Replies
Custom (Reusable) DAX Function please vote :}
It only took 7 years to MS to deliver this kind of functionality. (private preview). what.a.joke.
Now it is possible 🙂
Just as a reference, if anyone searches for this problem and comes to this post as I did..
my way of simulating this kind of functions is creating DAX measures always using variables like that:CustomColumn = // define the parameters and where to get their values var param_startdate = related('abc'[abc]) var param_enddate = 'xyz'[xyz] // the actual function goes here return datediff(param_startdate,param_enddate,MINUTE)
that way I created a little library for my own reference where I can quickly find such functions and can easily reuse them.Thanks. However, do I understand correctly that the reuse happens via copy & paste?
