How to sum up the count measure by month and year instead of date

[Tayaba]

I am trying to sum up the count values of my table. Currently i have two tables. I linked the table together by date. In my data i had the date to be formatted as 11/01/2019, 11/02/2019 ..... so i converted the date to show the date as Nov-2019. 

The problem is that when i add my measure the measure of the count is displayed by date instead of month and year. 

I want Nov-19 to add all its number and show as one month instead of separating out by date. I tried the pivot table option and it didn't seem to work for me. 😕 

[Kushal_Chawda]

how your month is calculated?

[sunny_talwar]

Are you using Date() function to just change the format of your date? You would actually need to use MonthStart() or MonthName() function to convert any date in a particular month to 1st of the month

Date(MonthStart(DateField), 'MMM-YY') as Month
or
MonthName(DateField) as Month

[teiswamsler]

Hi Tayaba

It seems you have a hidden timestamp in your data field.

try remove the timestamp by using Floor() and then converting back to desired data format using Date()

Date( Floor( [DateField] ), 'MMM-YYYY' ) as YearMonth

Teis