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 (59)
- Merged Idea (1)
RE: Custom (Reusable) DAX Function
Unforgiveable that this has yet to be implemented, no wonder powerBI is not even more popular than it should be
RE: Custom (Reusable) DAX Function
IMHO, this is nothing but a Calculation Group that is applied to a measure by default at the measure level as opposed to being applied globally to all selected measures manually using a filter. That seems an easy addition. Calculation Groups are really just repetitive calculations that pass in an input measure using SELECTEDMEASURE. Despite the use case that everybody demonstrates, they are not just intended for time intelligence calculations.
RE: Custom (Reusable) DAX Function
Hi,I have dax code with 35 lines for each kpi and I don't understand that "personal function" is not yes implemented in Power BI ! So I have to duplicate this code for more than 50 KPI !!!When could you answer at this lack ?
RE: Custom (Reusable) DAX Function
Please implement this feature.This is a must! for a serious programing language.Thanks.
RE: Custom (Reusable) DAX Function
Please implement this!!! I waste so much time copy/pasting similar code, which could be fixed by creating a custom reusable function with passthrough variables...
RE: Custom (Reusable) DAX Function
Would be useful if you had the ability to create your own DAX functions that allows for variables to be inserted into the function.
I find that quite often I require a Base Measure that only subtly needs changing. Eg, Groups by a different dimension in a SUMMARIZE formula, or alternately uses a different SUM measure to produce a different result with the same manipulation of the rest of the DAX Formula.
This will allow for the Base Measure to be adjusted if a more effective solution emerges, rather than requiring a change for every single measure that the function has been applied to.
RE: Custom (Reusable) DAX Function
All we need are UDF to return results. I get they will need context but it will save ALOT of coding hrs is to be able to do something like:IF(A, Function(param),IF(B,Function(param),etc....
RE: Custom (Reusable) DAX Function
Dear Microsoft Power BI Team, every serious developer working with DAX code will say that this feature is a must be.The question is when Custom functions will be available?
RE: Custom (Reusable) DAX Function
More that 5 years and still UNDER REVIEW?! Seriously?! Hurry up Microsoft! You should act before even people think about it! This is a VERY BASIC feature. QBasic had it 20 years ago!
RE: Custom (Reusable) DAX Function
Unbelievable that this is still not being picked up. How many more votes would the PBI dev team need before this is addressed? Opened since 5 years and still no sign of anything that is remotely going to support this basic request? Not sure if this will make any change, but I voted anyway.