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

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.