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 ...
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.
sevenhills
Super User
Super UserSay, 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.