Forum Discussion
WhaleWatcher222
Helper II
Helper IIIgnore 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 Labe...
IsFutureDate = IF('Date'[Date] IN CALENDAR(TODAY()+1,dt"2026-03-31"),1,0)
lbendlin
Super User
Super UserIsFutureDate = IF('Date'[Date] IN CALENDAR(TODAY()+1,dt"2026-03-31"),1,0)