Forum Discussion

mork's avatar
mork
Helper V
10 years ago

Group By month

Hello all, I have a table of my Resources work per week that I'm trying to group by month. How can I do that? Example table bellow.     ResourceName                   Week#                 WeekSt...
Need Help
mork's avatar
mork
Helper V
10 years ago

I tried using the MONTH function like bellow:

 

 

=MONTH([WeekStartDate]) 

And I get the following error.

 

"The name 'MONTH' wasn't recognized. Make sure it's spelled correctly.

 

Also how can I add the YEAR function to that? I want a format that would look like "Month-Year".

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi mork,

 

   I think you're searching this:  monthYear = MONTH(table[WeekStartDate]) & "-" & YEAR(table[WeekStartDate]).

  • mork's avatar
    mork
    Helper V
    10 years ago

    Anonymous That should work but it doesn't. I get the same error.

     

    What I'm doing is that in powerquery I select the "add column" tab and then I select "add custom column". A window pops up and I write the formula in the window. But the formula is in DAX language and not in M. Maybe that's the error? But I don't want to create a calculated column outside of powerquery because I want to group according to that column.