Add Week over Week calculation in Time Intelligence Measures?

[mohita1010]

As of now I see Month on Month and Year on year calculations but at times we also need Week over Week calculation in Time Intelligence Measures? I think it will be a great value add for people who work on Weekly reports.

[mauriziomail81]

It would be really convenient to align the M function Date.WeekOfYear to the Excel WEEKNUM function to return a ISO 8601 compliant week number. Time intelligence properties are the starting point for a plethora of other calculations. And this "tile" is missing.

[jeffrey_wang]

If all you need is to add a column to a table, one option today is to add a calculated column using DAX WEEKNUM function that behaves identically to Excel's.

[roberto_campass]

Thank you very much for your suggestion, Jeffrey. However, it would be much better to be able to reference a Power Query table cell for other interim evaluations and calculations... before loading all the needed structures in DAX and without writing kilometers of code only to obtain this result.

[maksym2]

Dear Jeffrey, unfortunatelly DAX function like M functions both returns incorrect week number, it's not ISO number

[LUC_VANDE_PLAS]

That doesn't seem to fix the problem: Expression error: The name 'weeknum' wasn't recognized. Make sure it's spelled correctly. input given: =weeknum(date,21)

[Richard_S]

My company not only reports on monthly numbers, but also weekly. Thus it would be nice to have time intelligence functions like Previousmonth, but for weekly periods, so that WoW calculations are much easier to create etc.

[fbcideas_migusr]

DAX function DATESINPERIOD should add support for weeks in addition to the current periods defined. Or ideally, it should support a custom period entered as an integer (so I could do hourly, bi-weekly, whatever I feel like).

[hauke_basse]

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.

[cristibalog]

You can use a calendar table linked to your Date column

[moreau]

This is a workaround until this is implemented : https://gist.github.com/r-k-b/18d898e5eed786c9240e3804b167a5ca