Forum Discussion

m_arias's avatar
m_arias
New Member
7 years ago
Solved

Index-Match-Max Formula

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

 

  • 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.

1 Reply

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    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.