how to create a measure in power bi for search the major value in four column

[diegolima]

Hello guys, how are you?

I have a four-column table with some values, a column that identifies the device that made these measurements of the values in the four columns, and a date column that shows what day those values are from. I need to make a column that looks for the highest value of the day for the device.

Can anybody help me?

Thank you all!

[nvprasad · Accepted solution]

HI,

You can get this by below Dax.

HighestValue =MAX(MAX(MAX('Table'[Value1],'Table'[Value2]),'Table'[Value3]),'Table'[Value4])

Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂

Regards,
N V Durga Prasad