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 ...
Hi, its only a column defined as date field...
UPDATE:
And as I written in my first message,
with COUNT('TABLE'[Date].[Month]) the Value is 1096,
with DISTINCTCOUNT('TABLE'[Date].[Month]) it is 12 ...
But what is "1096" ? :)
vega
Resolver III
Resolver IIII believe 1096 is the number of dates in your date column