Add labels to range of dates

[Flavio2021]

Hi  I am new in this world and are already several days that I don't found a solution to my problem that is

I have a column of date from Nov2018 today and what I would like to reach as result is that in a range of date, like 1Nov2018 to 31Oct19 I have a label like FY19 and so on for the other FY years  Found complex solutions,  but I need a very simple formula

Have you some suggestion

?  

[bicoffee · Accepted solution]

Hi,

you can use group option where you can create groups based on the range.

[ryan_mayu · Accepted solution]

@Flavio2021 

you can create a new column

Fiscalyear = if(month('Table'[Date])>10,year('Table'[Date])+1,year('Table'[Date]))

[ryan_mayu · Accepted solution]

@Flavio2021 

you can create a new column

Fiscalyear = if(month('Table'[Date])>10,year('Table'[Date])+1,year('Table'[Date]))

[Flavio2021 · Accepted solution]

Hi Great Job !  Replicated and it done what I need    

Thank !

[bicoffee · Accepted solution]

Hi,

you can use group option where you can create groups based on the range.

[Flavio2021]

Need to test and mainly learn how to use but has sense.