Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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.
Status: Needs Votes
Comments
martinwdd
Regular Visitor
This would be very useful!
fbcideas_migusr
New Member
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.
fbcideas_migusr
New Member
Status changed to: Needs Votes