Forum Discussion

Matty's avatar
Matty
Helper II
9 years ago

Using a slicer based on a joined table...

Hi,   I've got two tables: one is 'sales' data with a single date column; one is 'date' data containing ISO weeks, periods and years, etc.   I've linked the two tables so that I can filter my sal...
Need Help
opticshrew's avatar
opticshrew
Resolver II
9 years ago

Hi there,

 

You could create a seperate data table using the calendar function.

 

Date =CALENDAR (DATE(2000;1;1); DATE(2025;12;31))

 

Here you could set the maximum date to the latest date in your sales column.

 

Additionally you could create a slicer that is based off of the sales data. This will only show values that exist within this table.

 

Thanks,

J