How to sum up the count measure by month and year instead of date
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. 😕