Forum Discussion
Date/Time Filter group by month
I have a Date/Time column which I want to filter on. However, when I try to filter it lists each day individually. However I want to group these by Month. For example I want to Count number of Co...
Hello,
I found out how to do this in an easier way.
1. Edit Query
2. Take the Date column you want and Duplicate it in the Transform Tab
3. In the Transform Tab under Date & Time Column Select Date drop down
4. Delect Month > Name of Month
This worked for what I was trying to do.
I tried that & it worked but unfortunately it wont allow me to save it because it
cannot make the changes on a live connections :-(. Any work around for live connections(I am using Direct Query)
I've got the same problem; did you fix it? Thanks in advance.
