Putting 2 values based on dates in 2 columns on the same graph.

[qwaszx55]

We have a simple table like so:

Item, Start Date, End Date, Monthly_Total

It is easy enough to show growth by graphing monthly total by start date.

And its easy enough to show cancels by graphing monthly total by end date.

I want them both on the same graph though. What would be the ideal way to change the data structure to allow this? (In direct query mode)

I had thought about making a new table with just:

Month, Growth, Cancels  and just graphing that but In direct query mode I can't add additional tables. 

[v-chuncz-msft]

@qwaszx55,

You may add a calendar table at the source and use measures.

https://community.powerbi.com/t5/Desktop/Create-a-Clustered-Column-Chart-using-Two-Summarize-Measure...

[qwaszx55]

You can't create a custom table when using direct query mode.

I've added a calendar to our backend database but am still having issues with the dax forumla.