Našimi kurzy prošlo více než 10 000+ účastníků
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
This article explains how to use the SAMEPERIODLASTYEAR function (or TOTALYTD, DATEADD, PARALLELPERIOD, PREVIOUSMONTH…) together with filters / slicers.
This can be more complicated than it seems.
Let´s demonstrate it on this table, showing dates, numbers and categories.
If the syntax is like this, then it somehow works. In visual we can see current values as well as previous year values:
But when you select some category (using filter, slicer etc.), there is something wrong:
Let´s start with a new table (dimension) creation, using the CALENDARAUTO function:
This should be connected with the original table, using relation.
Now change the syntax of measure. ALL function wouldn’t be used. SAMEPERIODLASTYEAR will use the date column from time dimension, which will be also used in visual.
From now, it works perfectly – no matter how many filters is used.
Comments are closed.
2 392 ověřených referencí účastníků našich kurzů. Přesvědčte se sami
Pište kdykoliv. Odpovíme do 24h
© exceltown.com / 2006 - 2023 Vyrobilo studio bARTvisions s.r.o.
It is recommended practice to use “calendar table” marked as “date table” when using Time Intelligence functions.
Clear and simple explanation. Thank you!