Forum Discussion
Creating a filter to only show items which have changed week to week
Hi, I'm in the process of creating a matrix visual. The matrix visual shows values for 2 seperate weeks. However, I want the table to only show values where theres been a change week to week. ...
see attached.
Ashish_Mathur
Super User
Super UserHi,
Sorry but i cannot work it out.
no worries, thanks for having a go 🙂
try this link
link- lbendlin
the download link seems to have expired.
- lbendlin
see attached.
this is great! The only thing is it doesnt change when the week changes.
Would you mind just explaining what is happening in the measure in simple terms?
- lbendlin
in the current filter context find the penultimate date. Then for that date find the value. Then compare that value to the value for the ultimate date. Use the resulting measure as a visual filter.
You can choose how many data points to include, it will always compare the last two.