Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to identify minimum value in the same row

Hi, team!

I'd like to know how to idenfity minimum value in the same row.
Below is detail.

 

------------------------------------------------------------


<What I'd like to know>

How to identify minimum value among Year 2015-Year 2021 by each "Products" in the same table named "Sales" as following.


<Output image>
Column "Minimum value" and "Minimum year" are output I'd like to get

 

<Background>

  • Function "min" need "Column" , so I could'nt use this function in such situation
  • I reseached the function which can compare scalar of each argument, but I couldn't get it

------------------------------------------------------------

Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    3 years ago

    Hi,

    I suggest unpivotting it in Power Query Editor.

    Or, if Power Query Editor is not reachable, try creating a virtual tables those contain two columns (Product column and one of Year columns)  inside a DAX measure, and then union all of them. And then MIN dax function can be possible used.

    Thanks.

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    3 years ago

    Hi,

    I suggest unpivotting it in Power Query Editor.

    Or, if Power Query Editor is not reachable, try creating a virtual tables those contain two columns (Product column and one of Year columns)  inside a DAX measure, and then union all of them. And then MIN dax function can be possible used.

    Thanks.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Jihwan_Kim 

    Thank you for your prompt help!

    Anonymous wrote:

    Hi, team!

    I'd like to know how to idenfity minimum value in the same row.
    Below is detail.

     

    ------------------------------------------------------------


    <What I'd like to know>

    How to identify minimum value among Year 2015-Year 2021 by each "Products" in the same table named "Sales" as following.


    <Output image>
    Column "Minimum value" and "Minimum year" are output I'd like to get

     

    <Background>

    • Function "min" need "Column" , so I could'nt use this function in such situation
    • I reseached the function which can compare scalar of each argument, but I couldn't get it

    ------------------------------------------------------------

    -->I understand your comment. Normally, it's impossible to compare and get minimum value for same record.