Finding minimum of 5 measures

[Anonymous]

Hi

I have created 5 measures using DAX

Say a, b, c, d and e.

Now I'm supposed to find a minimum from these 5 measures.

Any Ideas

Thanks,

Ganesh

[v-yuta-msft]

@Anonymous ,

As you mentioned, you can create a new measure using DAX:

Measure = MIN(MIN(MIN(MIN(MIN([Measure1], [Measure2]), [Measure3]), [Measure3]), [Measure4]), [Measure5])

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Result = min(a,min(b,min(c,min(d,e))))