Lowest value (DAX variables)

Asked

Viewed 58 times

1

I need to create a measure (MAX) that calculates the smallest among several variables, also what we have in Excel called "SMALLER"...

My attempt is as follows ("Unsuccessful")

M_Teste =
var v1 = 10
var v2 = 8 
var v3 = 11
var v4 = 9
return min(v1,v2,v3,v4)

I tried to create a DATATABLE to create a virtual table to use MINX, but I could not!

powerbi dax

1 answer

0

It would be possible through MINX.

M_Teste = 
   var v1 = 10
   var v2 = 8 
   var v3 = 11
   var v4 = 9
return 
   MINX({v1,v2,v3,v4},[Value])

Browser other questions tagged powerbi dax

You are not signed in. Login or sign up in order to post.