I am using the sample code “Date Query” but in my case the Fiscal Date must have another period.
for exemple: from 01 july 2015 to 30june 2016 is for FY15
with the code below the result is FY16.
AddFY = Table.AddColumn(InsertShortYear, “FY”, each “FY”&(if [MonthOfYear]>=FYStartMonth then Text.From(Number.From([ShortYear])+1) else [ShortYear]))
Can you give me a help?
thanks for your help