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/
danextian
Super User
Super UserHi rantel ,
You still have to aggregate. MIN function takes either a column or two expressions but not an expression and anotherr column. Wrap the date column in MIN, MAX or SELECEDVALUE to satisfy its requirement. Your formula should be:
=
MIN ( MIN ( 'Sample Table'[ColDateEnd] ), [EndDate] )
