Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (16) Share
    A Power BI User's profile image

    A Power BI User 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)
    A Power BI User'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.

    A Power BI User'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!