Forum Discussion
Solved
Measure to get the earliest last date
Hi All I would like to know if it possible to create a measure that get the earliest last date from table with a date and work it base and work with the filter context? Have the following ta...
Please try this measure expression, replacing T1 for your actual table name.
Min Max =
VAR vMaxDates =
SUMMARIZE (
T1,
T1[Customer Id],
"cMaxDate", MAX ( T1[Log Date] )
)
RETURN
MINX (
vMaxDates,
[cMaxDate]
)Pat
mahoneypat
Microsoft Employee
Microsoft EmployeePlease try this measure expression, replacing T1 for your actual table name.
Min Max =
VAR vMaxDates =
SUMMARIZE (
T1,
T1[Customer Id],
"cMaxDate", MAX ( T1[Log Date] )
)
RETURN
MINX (
vMaxDates,
[cMaxDate]
)
Pat