I am new with Power Bi. I want to add a custom column for Fiscal years with the help of order date. Here is my formula.Fiscal Year=Number.RoundDown((12*Date.Year([Order Date]) + Date.Month([Order Date]) + 12- YearOfEnd)/12,0) What is wrong as YearOfEnd function is not recognized?

1

1 Answer

I did a search and found the below link:

Your Answer

Sign up or log in

Sign up using Google Sign up using Facebook Sign up using Email and Password

Post as a guest

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.