Forum Discussion
Solved
Caculate Semester
Morning all,
I need to calculate semester from a date stored in a column in Power Query like:
01/01/2022 ==> S1
07/18/2022 ==> S2
I've tried the built-in functions of Power Query but I only for Quarter.
Any help will be appreciated, thanks in advance.
Here is one way to do it. Add a custom column with an expression like this.
= "S" & (if Date.Month([Date]) >=7 then "2" else "1")
Pat
1 Reply
Here is one way to do it. Add a custom column with an expression like this.
= "S" & (if Date.Month([Date]) >=7 then "2" else "1")
Pat