Ignore future date using FY

[WhaleWatcher222]

Hi Experts

How can i amend the following dax caclulated column to ingore all future date beyond FY2026. FY runs from 01/04 to 31/03

IsFutureDate = IF('Date'[Date] <=  'Date'[Fiscal Year Label] = "FY2026",1,0)

[lbendlin · Accepted solution]

IsFutureDate = IF('Date'[Date] IN CALENDAR(TODAY()+1,dt"2026-03-31"),1,0)