Forum Discussion
Solved
Ignore future date using FY
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)
IsFutureDate = IF('Date'[Date] IN CALENDAR(TODAY()+1,dt"2026-03-31"),1,0)
1 Reply
IsFutureDate = IF('Date'[Date] IN CALENDAR(TODAY()+1,dt"2026-03-31"),1,0)