on 26 Sep 2018 13:05:09
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.
- Comments (22)
RE: Add Week over Week calculation in Time Intelligence Measures?
When will this be developed and rolled out?
RE: Add Week over Week calculation in Time Intelligence Measures?
Absolutely indispensible !
RE: Add Week over Week calculation in Time Intelligence Measures?
This is a workaround until this is implemented :
https://gist.github.com/r-k-b/18d898e5eed786c9240e3804b167a5ca
RE: Add Week over Week calculation in Time Intelligence Measures?
You can use a calendar table linked to your Date column
RE: Add Week over Week calculation in Time Intelligence Measures?
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.
RE: Add Week over Week calculation in Time Intelligence Measures?
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).
RE: Add Week over Week calculation in Time Intelligence Measures?
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.
RE: Add Week over Week calculation in Time Intelligence Measures?
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)
RE: Add Week over Week calculation in Time Intelligence Measures?
Dear Jeffrey, unfortunatelly DAX function like M functions both returns incorrect week number, it's not ISO number
RE: Add Week over Week calculation in Time Intelligence Measures?
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.