cancel
Showing results for
Did you mean:

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Anonymous
Not applicable

## How to get Fiscal year end date based on today's date

Hi All,

I have a column which holds today's date.Now, my requirement is to generate a Fiscal year end date in new column based on Today's date.

In my data fiscal year starts from 1st April to 31st March.

Ex:Today's date is 01/10/2021 based on that date i have to generate a column which should show fiscal year end date that is 31/03/2022.

Can someone help on this.

1 ACCEPTED SOLUTION
Resolver III

Hi Harika,

Year=YEAR(Data[Date].[Date])
Month = MONTH(Data[Date].[Date])

For fiscal year use below calculated column

Fiscal Year = if((Data[year]=YEAR(TODAY()) && Data[Month]>=4), DATE(year(TODAY())+1,3,31),if((Data[year]=YEAR(TODAY())+1 && Data[Month]<=3), DATE(year(TODAY())+1,3,31)))

2 REPLIES 2
Resolver III

Hi Harika,

Year=YEAR(Data[Date].[Date])
Month = MONTH(Data[Date].[Date])

For fiscal year use below calculated column

Fiscal Year = if((Data[year]=YEAR(TODAY()) && Data[Month]>=4), DATE(year(TODAY())+1,3,31),if((Data[year]=YEAR(TODAY())+1 && Data[Month]<=3), DATE(year(TODAY())+1,3,31)))

Resolver III
Fiscal Year End1 = if((Data[year]=YEAR(TODAY()) && Data[Month]>=4), DATE(year(TODAY())+1,3,31),if((Data[year]=YEAR(TODAY())+1 && Data[Month]<=3), DATE(year(TODAY())+1,3,31),if((Data[year]<> YEAR(today()) && Data[Month] >=4),DATE(YEAR(Data[Date].[Date])+1,3,31),if((Data[year]<> YEAR(today()) && Data[Month] <=3),DATE(YEAR(Data[Date].[Date]),3,31),if((Data[year]=YEAR(TODAY()) && Data[Month]<=3), DATE(year(TODAY()),3,31))))))

Announcements

#### New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

#### Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

#### Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors