Skip to main content

    Power BI

    New

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

    Vote (16) Share
    Alessandro's profile image

    Alessandro 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's profile image Profile Picture

    5a09c956 9d3e-4112-9039-492d22b24fa0 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's profile image Profile Picture

    62f3f804 cce2-4834-9944-e14dedf7bb22 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!