Forum Discussion
not using date slicer but instead allow user to enter from a date picker for start and end date
- 2 years ago
Hi,
This is possible to achive. Then you need two date tables.
This two tables cant have any relationships to the fact, just be stand alone.
Then you need slicers, one for each data table so the end user can pick from - and to date.
At last you need to create a measure on the fact table with the correct aggregation (sum, count or What you need), with a filter Where start date is >= the first date end user pick and end date <= the other.
Br
Marius
Hi,
This is possible to achive. Then you need two date tables.
This two tables cant have any relationships to the fact, just be stand alone.
Then you need slicers, one for each data table so the end user can pick from - and to date.
At last you need to create a measure on the fact table with the correct aggregation (sum, count or What you need), with a filter Where start date is >= the first date end user pick and end date <= the other.
Br
Marius