233 votesHauke supported this idea ·Hauke commented
It just cost me quite some time to see that the M-function in Query-Editor, which is generated by
Add Column - Date - Week - Week of Year
really behanved different from the function "WEEKNUM".
It really is solved quite satisfactory in Excel.
It should REALLY by introduced into M, so that I can append tables with WEEK-comlumns efficiently in query designer.