Caculate Semester

[FranckGbadamass]

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.

[mahoneypat · Accepted solution]

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