Change the FY date period


#1

Hi,
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]))
in
AddFY

Can you give me a help?

thanks for your help


#2

Hi PAM,

I had a quick play around and came up with this.

Can you try it and let me know if this is what you required.

AddFY = Table.AddColumn(InsertShortYear, "FY", each "FY"&(if [MonthOfYear]>=FYStartMonth then Text.From(Number.From([ShortYear])) else Text.From(Number.From([ShortYear]) - 1)) )

Thanks


#3

Hi Sam,
is running good, thanks for your reply!!!