Let’s say you want to use the slicer below for a date range. How would you calculate values based on this slicer if the dates are not consecutive? most of the time intelligence functions require consecutive dates. Any ideas?
I know how to get the selected values from the slicer with no problem, just not how to use them to get the sum of other fields for the time period selected.