Microsoft Power BI - Financial Year Calculation (2023 April - 2024 March) need to be show in report

[rajkumarg1991]

Dear mates,

One of the column in my table is having Financial Year and Date. That needs to be transformed into "Current Financial Year". If the Financials year exist in between 2023 April - 2024 March in 'Date' column.

Financial Year =

IF(IF(MONTH(TODAY()) <=3,YEAR(TODAY())-1 & "-" & YEAR(TODAY()),YEAR([Date]) & "-" & YEAR(TODAY()) + 1) =

IF(MONTH([Date]) <=3,YEAR([Date])-1 & "-" & YEAR([Date]),YEAR([Date]) & "-" & YEAR([Date]) + 1),"Current Financial Year",

IF(MONTH([Date]) <=3,YEAR([Date])-1 & "-" & YEAR([Date]),YEAR([Date]) & "-" & YEAR([Date]) + 1))

And its working fine until 31/12/2023 after that its showing 2023-2024 in the Financial Year column. It needs to be showed "Current Financial Year" and  transformed until 31/3/2024(Date) in the Financial year column.

Below shown table is from Power Bi,

Please someone help me to solve this problem.

Thanks in advance,

[v-zhangti · Accepted solution]

Hi, @rajkumarg1991 

You can try the following methods.

Start date of the financial year = IF(MONTH([Date])<4,DATE(Year([Date])-1,4,1),DATE(Year([Date]),4,1))

Financial year = IF(YEAR([Start date of the financial year])=Year(TODAY()),"Current Financial Year",YEAR([Date])-1 & "-" & YEAR([Date]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rajkumarg1991 · Accepted solution]

Dear Team,
I got it. Thank you so much! for helping it out.

[v-zhangti · Accepted solution]

Hi, @rajkumarg1991 

You can try the following methods.

Start date of the financial year = IF(MONTH([Date])<4,DATE(Year([Date])-1,4,1),DATE(Year([Date]),4,1))

Financial year = IF(YEAR([Start date of the financial year])=Year(TODAY()),"Current Financial Year",YEAR([Date])-1 & "-" & YEAR([Date]))

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.