Forum Discussion
Putting 2 values based on dates in 2 columns on the same graph.
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.
2 Replies
You may add a calendar table at the source and use measures.
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.
