More DAX functions: Unpivot calculated columns and max/min of multiple columns
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.
Kenneth Barber commented
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.
Martin Werner commented
This would be very useful!