Forum Discussion
Slicer - How can I count selected months?
Hi Guys, how can I or is it possible to count how many months I have selected in a Date-Slicer? I want to divide a value with the count of monts, e.g. earnings / selected months ... All variants ...
Months Counted in Slicer =
IF(
ISCROSSFILTERED('Date Table'[Month]),
DISTINCTCOUNT('Date Table'[Month])
)