Forum Discussion
Solved
Sum data based on date range
Hi Im trying to create a column chart which displays the number of tasks per month that have a shipping date relevant to that month. I have 1 table called tasks. In tasks i have task name and task ...
Have you tried to create a calculated column based on the specific date and create a column chart based on the shipping month.
shipping month = DATE(YEAR(Task[ShippingDate]),MONTH(Task[ShippingDate]),1)
Have you tried to create a calculated column based on the specific date and create a column chart based on the shipping month.
shipping month = DATE(YEAR(Task[ShippingDate]),MONTH(Task[ShippingDate]),1)
thankyou - i was able to add a grouping to the date on x axis- which allowed me to create a bin which i selected per month (voila!!)
So isn't adding a grouping work for you now? If not, could you be more specific? I don't get too much idea from the original post.