Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Financial Year Generate

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

General Comment
Tips and Tricks
Tutorial Requests
  • TeigeGao's avatar
    TeigeGao
    7 years ago

    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

1 Reply

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    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