Financial Year Generate

[Anonymous]

Hi All,

I have one Date column, So i want create FN year lastday  calculated column by using my date column.

here, i'm sharing my example.

Date                        FNYear
01-01-2019     31-03-2019
02-01-2019     31-03-2019
03-01-2019     31-03-2019
04-01-2019     31-03-2019
05-01-2019     31-03-2019
06-01-2019     31-03-2019
31-03-2019     31-03-2019
01-04-2019     31-03-2020
02-04-2019     31-03-2020
03-04-2019     31-03-2020
04-04-2019     31-03-2020

Adv thanks

Naveen

[TeigeGao · Accepted solution]

Hi @Anonymous ,

In your scenario, we can use the following DAX query:

FNYear =
IF (
    MONTH ( Table1[Date] ) <= 3,
    DATE ( YEAR ( Table1[Date] ), 3, 31 ),
    DATE ( YEAR ( Table1[Date] ) + 1, 3, 31 )
)

Please refer to the following result: 

Best Regards,

Teige