Index-Match-Max Formula

[m_arias]

Hello,

I need some help, 

I need to find the DAX formula that helps us know with is the column name that have the high amount in each column.

I have the following information:

A  Current  Past Due  1-10

1    $1           $450       $50

2    $300       $5          $350

For example in excel I use INDEX (Titles of the table, Match(Max(Each line),Each line,0))

And the result in Excel for each row will be :

First row: Past due

Second row: 1-10

Thanks a lot

[v-yuta-msft · Accepted solution]

@m_arias ,

You can click query editor-> Transforms-> Unpivot columns "Past_Due" and "1-10", then you can create measures based on your requirement.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.