Compare dayweek to dayweek
I need a sample to compare day of week to last year day of week.
Currently I have LY measure, that is used as parallelperiod, but it is not OK, because it goes one year back and compares date to date. But for example. I need to compare this monday to last year monday in the same range
In the attachment is sample. Empty space in C column is what I would like to get.
Easiest would be to use ParallelPeriod with a Date hierarchy based on weeks, rather than months, i.e. Year --> Week no. --> Date. If it is possible to have that added to your data model, that is the most straightforward approach, then your parallel period will automatically compare the same day of the week to the same week number when it goes back one year.
If all you have is one Date hierarchy (or no date hierarchies) in months, it is more complicated. You could use .LAG(366) to find the same date -1 a year ago (ie the same day of the week), but you will also have to test if the year is a leap year and adjust the .LAG() to .LAG(367). This is, of course, assuming your date dimension includes all dates of the year.Reply
I have created measure that is working just fine. Not With LAG 367, but with LAG 364. I also created parallelperiod with weeks, rather than months. and moved not for 1 year, but for xx weeks back.
Now I have the issue with visual totals, because it is not showing for this calculated measure. Do you happened to know, what can be the cause of it?