Skip to main content

    Power BI

    Under Review

    Custom (Reusable) DAX Function

    Vote (718) Share
    Omaer Khan's profile image

    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)
    Omaer Khan's profile image Profile Picture

    Kimmo on 06 Jul 2020 00:13:45

    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

    Omaer Khan's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:13:36

    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.

    Omaer Khan's profile image Profile Picture

    Robert Mela on 06 Jul 2020 00:10:59

    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.

    Omaer Khan's profile image Profile Picture

    jeffrey Weir on 06 Jul 2020 00:09:38

    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/

    Omaer Khan's profile image Profile Picture

    Ben Wefers on 06 Jul 2020 00:09:35

    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.

    Omaer Khan's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:05:43

    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.

    Omaer Khan's profile image Profile Picture

    Power BI User on 06 Jul 2020 00:05:29

    RE: Custom (Reusable) DAX Function

    Please add User defined functions to Power BI

    Omaer Khan's profile image Profile Picture

    Jose on 06 Jul 2020 00:05:03

    RE: Custom (Reusable) DAX Function

    Yes, please add to Power BI.

    Omaer Khan's profile image Profile Picture

    Kevin on 06 Jul 2020 00:03:13

    RE: Custom (Reusable) DAX Function

    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.

    Omaer Khan's profile image Profile Picture

    Juliusz Gonera on 06 Jul 2020 00:01:05

    RE: Custom (Reusable) DAX Function

    '+1. I have a spreadsheet with only tens of custom measures and managing them all is already a nighmare.

    Merged Idea (1)