View My Drafts
I am trying to do a distinct count on number of months listed in a table based on Document Date.
The following formulas return a value of 12 even though only 7 months are listed in the actual dataset (Jan-Jul)
Any idea why these return 365 days or 12 months instead of 7? I confirmed that the start and end dates are January to July and that there are no other entries.
COUNTROWS ( SUMMARIZE ( Sales, Sales[DocumentDate].[MonthNo] ) )
Medida =COUNTROWS ( SUMMARIZE ( Sales, Sales[DocumentDate].[MonthNo] ) )