Forum Discussion
Modify m code date table
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
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.
1 Reply
sevenhillsSuper User
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.