Forum Discussion

JC2022's avatar
JC2022
Helper III
3 years ago

Fiscal Year To Date Flag

My Fiscal year starts the 1st of October. I have the formula below for my YTD flag, but I would also like to create a Fiscal YTD Flag. How do I do this? = Table.AddColumn(#"Inserted Day of Year",...
Need Help
Migasuke's avatar
Migasuke
Memorable Member
3 years ago

Hi JC2022 ,
It should work also for Previous FY:

 

 

Andrew_Butcher's avatar
Andrew_Butcher
Frequent Visitor
2 years ago

Hi Migasuke ,

 

I think what JC2022 meant was the Year to Date part of the function doesn't work for previous years. i.e in the above screenshot where it is 03.04.23 and the the 'year' starts 1st October, 10.04.22 and 30.09.22 should not be flagged as it has not reached those dates in the defined 'year'. Is there a way of building this into the expression?

JC2022 did you find a solution to this?

Thanks