Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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))
Solved! Go to 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 👍
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 👍
Awesome, that worked! thank you so much! 🙂