Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
But instead of the desired output it just shows me the total amount of revenue like this
Any tips or hints towards what I am doing wrong would be really helpfull and appreciated.
Thanks in advance!
Solved! Go to 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.
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.
Hi @Anonymous ,
Set your [DisplayableSubtotal] column to the "Don't summarize" and check if it works.
What is a “date” table for?
I would just add the month, year calc column to the "Sales" table
User | Count |
---|---|
94 | |
84 | |
78 | |
75 | |
66 |
User | Count |
---|---|
115 | |
105 | |
93 | |
65 | |
60 |