cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

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

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Financial Year Generate

Hi @naveenbobbala3 ,

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: 

PBIDesktop_yUkDU4oJG8.png

Best Regards,

Teige

1 REPLY 1
Community Support Team
Community Support Team

Re: Financial Year Generate

Hi @naveenbobbala3 ,

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: 

PBIDesktop_yUkDU4oJG8.png

Best Regards,

Teige

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 308 members 3,119 guests
Please welcome our newest community members: