How to Sum and display data monthly on graph?

[Simon911]

I have created a report of sendgrid requests but the data is on daily basis and when i create a report it displays only the sum of one day (i.e. the sum of Jan 1st 2016, Feb 1st 2016 and so on) instead of month. Can anyone suggest how to sum full month data for all months so that on graph it displays full months data as a whole.

Refer image attached. I want to sum all data of column "TotalEmailRequests" so that i can get my month data when i create graph.

[kcantor · Accepted solution]

If you add a date table it will work as you would like. You would relate your sales facts to the date table using the date key for each day. Then you would populate the graph with the month from the date table. Your original sum calculation should work and would roll up to the date table through the relationship.

check out this link:

http://www.powerpivotpro.com/2011/11/the-ultimate-date-table/