I'm getting the wrong dtate returned when trying use a measure to bring back the date prvious to the 'current date,
Filtered Table using max:=VAR MdateL = MAX(LastT[Date])
RETURN
MAXX(
FILTER(ALL(LastT[Date]),LastT[Date] < MdateL ), LastT[Date])
Filtered Using If has one:=MAXX(
FILTER(ALL(LastT[Date]),LastT[Date] < IF(HASONEVALUE(LastT[Date]),VALUES(LastT[Date]) ) ),LastT[Date])
So if the current date is 07/01/2020 and the previous 01/01/2020 so if in Rows I have 07/01/2020 values 01/01/2020
but it keeps adding one so I have 02/01/2020, im pretty certain the formula is ok so can't see whats causing it, i've checked data types,
please help.
Workbook attached,
Richard
Bookmarks