Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Min value from other columns

Hi , I need to create a custom column, which gives the lowest value from other columns.

ClassColumn_1Column_2Column_3Required_Results
A1161
B2 52
C2151
D4322
E5222
F64 4

 

Please help me

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Anonymous 

     

    You can use MIN function to get the lowest value from other columns while creating a new column-

     

    Column = MIN('TableName'[ColumnName])
     
    Appreciate your kudos !! Please mark my post as solution if this helps you.
  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    Anonymous 

    you can try this

    Column = if(ISBLANK('Table'[Column1]),min('Table'[Column2],'Table'[Column3]),if(ISBLANK('Table'[Column2]),min('Table'[Column1],'Table'[Column3]),if(ISBLANK('Table'[Column3]),min('Table'[Column1],'Table'[Column2]),min(min('Table'[Column1],'Table'[Column2]),'Table'[Column3]))))

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      ryan_mayu 

      I want to creat a  custom column. 

      • jthomson's avatar
        jthomson
        Icon for Solution Sage rankSolution Sage
        5 years ago

        Oh, you want a Power Query solution?