Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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,
Solved! Go to 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.
Dear Team,
I got it. Thank you so much! for helping it out.
Dear Team,
I got it. Thank you so much! for helping it out.
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.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |