Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
Reference: Global Superstore dataset
I would like get the total quantity of returned items by year but I am getting the total quantity of returns in entire dataset as shown below:
Below shows the relationship established:
Any help here? Thanks! I would like to know what went wrong or possible mistakes ive done.
Hi @Ed_Beach
There's no flow of relationship from DateTable and Returns tables. The DataTable affects the Orders table only thus your seeing the total count of returns regardless of the year. Does Orders have more than one row per Order ID?
Proud to be a Super User!
User | Count |
---|---|
98 | |
87 | |
77 | |
67 | |
63 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
58 |