Within Range =
VAR MinDate = MIN( FctoodDelivery[Date] )
VAR MaxDate = MAX( FctoodDelivery[Date] )
RETURN
IF(
AND(
Dates[Date] >= MinDate,
Dates[Date] <= MaxDate
),
TRUE(),
FALSE()
)
Of Useful Things
Within Range =
VAR MinDate = MIN( FctoodDelivery[Date] )
VAR MaxDate = MAX( FctoodDelivery[Date] )
RETURN
IF(
AND(
Dates[Date] >= MinDate,
Dates[Date] <= MaxDate
),
TRUE(),
FALSE()
)
Last Transaction Date =
LASTNONBLANK(Dates[Date], [Total Sales])
First Date =
Min Date = (Min(‘Dates’)[Date])
Max Date = (Max(‘Dates’)[Date])