Table that filters less than, equal and greater by 1 from another table

[andy808]

I have a Dates Table with FiscalYear column set from 2020 to 2060

The measure CurrentFiscalYear = 

CurrentFiscalYear = IF(MONTH(TODAY()) >= 7, YEAR(TODAY()) + 1, YEAR(TODAY()))

I have created a Table below that needs to be dynamic and return Current Fiscal Year (2024), all past years (2020-2023) AND 1 year after Current Fiscal Year (2025).

How do I add the 1 year after Current Fiscal Year 2025?

[Daniel29195]

@andy808 

try this : 

FiscalYearTest = 

VAR currentfiscalyear = year(today())

RETURN

Filter ( 
distinct (Dates[FiscalYear] ) , 

Dates[FiscalYear] <  = currentfiscalyear 
)

let me know if it works for you 

[andy808]

Thanks, this does not return the Year after the Current Fiscal Year. I am looking for the table to return 2020-2025. Basically Current Fiscal Year +1 year 

[Daniel29195]

@andy808 

try this : 

FiscalYearTest = 

CurrentFiscalYear = IF(MONTH(TODAY()) >= 7, YEAR(TODAY()) + 2, YEAR(TODAY()) +1 )

RETURN

Filter ( 
distinct (Dates[FiscalYear] ) , 

Dates[FiscalYear] <  = currentfiscalyear 
)

so if i understand correctly,

if im in month >=7, then my current fiscalyear should be 2025, and thus i need to get data from 2020 till 2026

however,

if the month <=7 then my currentfiscal year is 2024 and thus i need to get the data from 2020 till 2025.

am i right ? 

[andy808 · Accepted solution]

Thank you for helping....yes we do Fiscal Year

I used: 

FiscalYearTest = FILTER(DISTINCT(Dates[FiscalYear]),Dates[FiscalYear] <= (IF(MONTH(TODAY()) >= 7, YEAR(TODAY()) + 1, YEAR(TODAY()) + 1)))

And i got