Need Help Converting Excel Formula to Power Query Formula

[ca-traveler]

Good day all, 

Was wondering if someone could help me convert this formula to a power query formula? I am trying to convert the program need date to the fiscal year in the fiscal year column (please see pic below). Any help or guidance would be appreciated. Thanks in advance! 

Trent 

=IF((MONTH(P3)>=10),(YEAR(P3)+1),YEAR(P3))

[DOLEARY85 · Accepted solution]

Hi,

try this:  

if Date.Month([Date])>=10 then Date.Year([Date])+1 else Date.Year([Date])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[DOLEARY85 · Accepted solution]

Hi,

try this:  

if Date.Month([Date])>=10 then Date.Year([Date])+1 else Date.Year([Date])

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

[ca-traveler · Accepted solution]

Awesome, that worked! thank you so much! 🙂