Skip to main content

    Power BI

    Needs Votes

    More DAX functions: Unpivot calculated columns and max/min of multiple columns

    Vote (16) Share
    Alessandro Goretti's profile image

    Alessandro Goretti on 02 Nov 2016 18:34:06

    It seems there are no DAX formulas to unpivot multiple calculated columns in a new table and to easily calculate min or max of multiple columns.

    Tried to easily calculate min or max of multiple calculated columns with a function, but there's none.
    Then tried to unpivot my calculated columns (to have a single column on which calculate the min value) with a DAX formula in a new table, but there isn't a way known by the community (or a quick way) of doing this.

    Comments (2)
    Alessandro Goretti's profile image Profile Picture

    Kenneth Barber on 06 Jul 2020 00:00:48

    RE: More DAX functions: Unpivot calculated columns and max/min of multiple columns

    Import your data into Power Query first. You can unpivot your table in Power Query. You can use the GUI to achieve this, and it will generate code that uses either the Table.Unpivot function or the Table.UnpivotOtherColumns function. Then load your modified table to the Data Model.

    Alessandro Goretti's profile image Profile Picture

    Martin Werner on 05 Jul 2020 23:08:45

    RE: More DAX functions: Unpivot calculated columns and max/min of multiple columns

    This would be very useful!