Hello,
I am trying to get a custom column whose result will be the quarter of the fiscal year based on if the start is <= the first day of the first month of the quarter and the last day of the last month of the quarter. This formula worked for Q1 calculation:
= if Date.Year([COP Completed]) = 2023 and Date.Month([COP Completed]) <= 3 then "Q1-2023" else null
As soon as I try to make the nested if I am getting an error (as soon as I put a comma after "Q1-2023")
=if Date.Year([COP Created]) = 2022 and Date.Month([COP Created]) >= 10 and Date.Month([COP Created]) <=12 then "Q1-2023", if Date.Year([COP Created]) = 2023 and Date.Month([COP Created]) >= 1 and Date.Month([COP Created]) <=31 then "Q2-2023" else null
I have attached a picture of what this looks like in Power Query Custom Column
Bookmarks