Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi all
Australian FY runs from 1st July to 30th June.
I'm trying to build a date table in Power Query. Is there a way to change the format to show the financial year column as 2018 - 2019 as opposed to 2019 below?
The same would apply for the quarters. At the moment Q1 starts from 1st January. For us, Q1 starts from 1 Jul to 30 Sept and so forth.
At the same time, is it advisable to add this FY column using M via Power Query or thru DAX?
Solved! Go to Solution.
@Anonymous , Try like
if Date.Month([Date]) < 7 then Number.ToText(Date.Year([Date]) -1) & "-" & Number.ToText(Date.Year([Date])) else Number.ToText(Date.Year([Date]) ) & "-" & Number.ToText(Date.Year([Date]) + 1)
@Anonymous , Try like
if Date.Month([Date]) < 7 then Number.ToText(Date.Year([Date]) -1) & "-" & Number.ToText(Date.Year([Date])) else Number.ToText(Date.Year([Date]) ) & "-" & Number.ToText(Date.Year([Date]) + 1)