Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I need the DAX formulas for my Custom Financial year.
I have a change in my financial year
From 2015-2020, Eg: my financial year is Dec 2015 - Nov 2016 and dax formula should have to display like FY 2016
From 2021 my financial year starts from Jan 2021 - Dec 2021 and dax formula should have to display like FY 2021
Thanks
Solved! Go to Solution.
@Anonymous , In you date table have this- New column
FY = "FY " & year(Endofyear([Date], "11/30")) // Refer: https://www.youtube.com/watch?v=LbstAOFD2Vo
or
FY = "FY " & year(Endofyear([Date], "12/31"))
put a if condition to check year and shift between
Creating Financial Calendar - From Any Month (All 12 months calendar)
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
Hi @Anonymous ,
With all credit to @amitchandak reply.
What will be FY for Dec 2020 ? Assuming it will be FY 2021.
FY =
if ('Date'[Year] <= 2021,
"FY " & year(Endofyear('Date'[Date], "11/30")),
"FY " & year(Endofyear('Date'[Date], "12/31"))
)
Please find solution attached.
Hi @Anonymous ,
With all credit to @amitchandak reply.
What will be FY for Dec 2020 ? Assuming it will be FY 2021.
FY =
if ('Date'[Year] <= 2021,
"FY " & year(Endofyear('Date'[Date], "11/30")),
"FY " & year(Endofyear('Date'[Date], "12/31"))
)
Please find solution attached.
@Anonymous , In you date table have this- New column
FY = "FY " & year(Endofyear([Date], "11/30")) // Refer: https://www.youtube.com/watch?v=LbstAOFD2Vo
or
FY = "FY " & year(Endofyear([Date], "12/31"))
put a if condition to check year and shift between
Creating Financial Calendar - From Any Month (All 12 months calendar)
https://community.powerbi.com/t5/Community-Blog/Creating-Financial-Calendar-Decoding-Date-and-Calendar-1-5-Power/ba-p/1187441
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
39 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |