Modify m code date table

[Anonymous]

How do I modify the Enterprise DNA code date table to add a column like this. Here is the link for det m code

https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390

InsertTermin = Table.AddColumn(InsertMonth, "Termin", each if [Month] >= 1 and [Month] <= 7 then "Vår" else if [Month] > 7 and [Month] <= 12 then "Høst") else null

[sevenhills · Accepted solution]

Say, if your original code is like this

InsertMonth = Table.AddColumn(InsertCompletedQuarter, "Month", each Date.Month([Date]), type number),
      InsertStartOfMonth = Table.AddColumn(InsertMonth, "Start of Month", each Date.StartOfMonth([Date]), type date),
      

You change it as

      InsertMonth = Table.AddColumn(InsertCompletedQuarter, "Month", each Date.Month([Date]), type number),
      InsertTermin = Table.AddColumn(InsertMonth, "Termin", each if [Month] >= 1 and [Month] <= 7 then "Var" else if [Month] > 7 and [Month] <= 12 then "Host" else null, type text),
      InsertStartOfMonth = Table.AddColumn(InsertTermin, "Start of Month", each Date.StartOfMonth([Date]), type date),
      

Additionally, This link is very popular and a video is posted for explanation on the same link.