Forum Discussion

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. Class Column_1 Column_2 Column_3 Required_Results A 1 1 6 1 B 2 5 2 C 2 1 5 1 ...

Need Help

ryan_mayu

Super 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]))))