Forum Discussion
Distinct months..?
Hi, I have dates in a table with the format yyyymmdd. I want to populate a list in a report with distinct months with the format mmm How can I do this? Kent J.
I created a copy of the column ProductionDate with the format 'mmmyyyy'. Then I grouped by the copy (MonthYear) and summarized 'ItemCount'. Success!
tackytechtom
Most Valuable Professional
Most Valuable ProfessionalHi Anonymous ,
Are you using a measure instead of a column maybe?
You may share some data if you like so I can look into it, too!
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
I created a copy of the column ProductionDate with the format 'mmmyyyy'. Then I grouped by the copy (MonthYear) and summarized 'ItemCount'. Success!