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     ...
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

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