Forum Discussion

andreazambon's avatar
andreazambon
Helper V
3 years ago

Delta value between 2 weeks

Hi there.  I'm trying to calculate the delta% between th last week agree with my filter anche le last-1 week.   I try with this:     Delta%PerditaLast = VAR PercMaxWeek= if(MAX(DateTable[week...
Need Help
andreazambon's avatar
andreazambon
Helper V
3 years ago

Thanks for your reply, I think that I can use this to my case. 

Instead of this solution, what if I want to show the difference between a week and the previous one?

 

For example, in WK15 I want to show the difference between WK 15 and WK14, in WK 14 the difference between WK 14 and WK 13.. 

lbendlin's avatar
lbendlin
Super User
3 years ago

you would use the same approach. Remember that "MAX"  is dependent on the current filter context, and it has a different meaning in different parts of your visual. That way you can write a single measure that can  compare a value with its "previous"  incarnation.  (Note that the new windowing functions can also be used if you are looking for alternatives)