Relationship between date table and sale table not working

[Anonymous]

Hello Everyone,

I am trying to create a graph that shows me the revenue of each day, with the related, quarter, month and year. I created a relation between my date table and sale table like this. Relationship

But instead of the desired output it just shows me the total amount of revenue like this

Result

Any tips or hints towards what I am doing wrong would be really helpfull and appreciated.

Thanks in advance!

[Anonymous · Accepted solution]

The problem was that because I was using directquery that even though I changed the datetime to date as soon as I started created graphs it forgot I had done this so all the dates in the sale table still had times like 9:38, 10:44 etc which is what caused it to seem there was no relation. 

I found a way to create a new column which shows me the regular date and base the relationship on that column after which it worked.

[v-eachen-msft]

Hi @Anonymous ,

Set your [DisplayableSubtotal] column to the "Don't summarize" and check if it works.

[Anonymous]

What is a “date” table for?
I would just add the month, year calc column to the "Sales" table