Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

M Code for 'Week of Month'

Hello, I use the code below for my date table. I now need an additional column for 'Week of Month'. Accordingly, I wanted to amend the code with this one:   InsertWeekofMonth = Table.AddColumn(I...
Need Help
  • Fowmy's avatar
    Fowmy
    5 years ago

    Anonymous 

    Once you have added the following line the final output after 1st "in" should be " InsertWeekofMonth" that is the final output

    InsertWeekofMonth = Table.AddColumn(InsertChangedType, "WeekofMonth", each Date.WeekOfMonth([Date],Day.Monday), type number)

     

     

     

Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Once you have added the following line the final output after 1st "in" should be " InsertWeekofMonth" that is the final output

InsertWeekofMonth = Table.AddColumn(InsertChangedType, "WeekofMonth", each Date.WeekOfMonth([Date],Day.Monday), type number)

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Worked perfectly. Thank you.