Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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. 😕
how your month is calculated?
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
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