Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Good Morning, Good Afternoon or Good Evening All o/
I have a testing data-model consisting of four tables:
The orders' market is stated as context on the Ancillary Order Info table while my revenue info is housed within the Order Line Item Details table. When I attempt to identify total billing my Market, I get the same value accross all markets. I have also attempted creating a markets key table like the OrderID's, but with the same result.
What am I doing wrong with the relationships/model?
Thank you for your advice and/or direction.
The Usurper
I think those tables are still in Many to Many relation. All unique Order related information should be part of the order table
Thanks for jumping in to help, @amitchandak. To confirm: you're suggesting I rehash my "AncillInfo" table for orderid duplicates, then and if/when I find/correct those use the AncillInfo table as my "market" legend selector rather than creating a unique records table/key?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |