Calculated Column Max Date Less 1 day

[Anonymous]

Hi Experts

How would you alter the followin measure to give you the max date less one day 
Measure

Calculated Column = 
  VAR __Date = [Date]
  VAR __Max = MAXX('Table', [Date])
  VAR __Result = IF(__Date = __Max,1,0)
RETURN
  __Result

So if the MAX date is 

20.11.2022

one day less is 19.11.2022 this becomes 1 and all other days 0

[FreemanZ · Accepted solution]

Hi @Anonymous 

try like:

Calculated Column = 
  VAR __Date = [Date]
  VAR __Max = MAXX('Table', [Date])
  VAR __Result = IF(__Date = __Max,__Max-1,0)
RETURN
  __Result