Forum Discussion
How to use start and end dates in a Pivot table instead of a timeline
I have a date column in my Pivot table. I use a timeline to select the dates. However, this is a bit clumsy. I'd like to show fields for start date and end date. How can I then use those values a...
mathetes In the timeline control, I select all days from Monday to Friday of a week.
The question really is how to use variables in a pivot table, without the user having to select values in a timeline or slicer.
I'll post a file later.
As variant
Let say you have range of dates and source table
If range is not a table let add it to data model through PivotTable. Let build main PivotTable with adding it to data model.
In data model add calculating column to main table
and use it as the filter.