Forum Discussion

FranckGbadamass's avatar
FranckGbadamass
Icon for Helper I rankHelper I
4 years ago
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 fo...
Need Help
Tutorial Requests
  • mahoneypat's avatar
    mahoneypat
    4 years ago

    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

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

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