How to identify minimum value in the same row

[taimaizumi]

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

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

[taimaizumi]

@Jihwan_Kim 

Thank you for your prompt help!

---

@taimaizumi 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.

[Jihwan_Kim · Accepted solution]

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.