Forum Discussion
Solved
Use MIN in measure, calculated row wise without aggregation
How to get the MIN of two dates in a Measure function without any aggregation. This can be done using a computed column but the issue is that it is not computed dynamically. See screenshot: EndDat...
Hi rantel ,
How about this:
Measure = VAR _temp = { MIN ( 'Sample Table'[Value3] ), MIN ('Sample Table'[Value4]) } RETURN MINX ( _temp, [Value] )/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi rantel ,
How about this:
Measure =
VAR _temp = { MIN ( 'Sample Table'[Value3] ), MIN ('Sample Table'[Value4]) }
RETURN
MINX ( _temp, [Value] )
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Thanks Tom. This worked. Just had to do a small tweak to remove the MIN function call for the Measure column.
Measure = VAR _temp = { MIN ( 'Sample Table'[Value3] ), 'Sample Table'[Value4] } RETURN MINX ( _temp, [Value] )
