Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have 3 tables : Orders, Users and Calendar. Tables are related as below.
I need to create a barchart that will reflect weekly #Orders and #Users. Calendar is connected to UserCreationDate on one side, and OrderDate on the other.
How can I use Week field from calendar as the Axis Value in such case? How can UseRelationship be used?
Thank you!
Solved! Go to Solution.
@Anonymous , Make the join between user and date inactive and activate only when you need a report on the user table only. if needed use crossjoin to remove relationship .
Keep date and order activated. Ideally, you should one to Many between user and orders
How to user refer : https://www.youtube.com/watch?v=e6Y-l_JtCq4
@Anonymous , Make the join between user and date inactive and activate only when you need a report on the user table only. if needed use crossjoin to remove relationship .
Keep date and order activated. Ideally, you should one to Many between user and orders
How to user refer : https://www.youtube.com/watch?v=e6Y-l_JtCq4
User | Count |
---|---|
128 | |
108 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |