- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to calculate relatedtable properly
Schema:
I am trying to get quantitiy from Dealer Product and times it by overall in Product Price. The tables are both many to many with eachother so I cant relate them. But they both connect to the Dealer table.
I was trying to make sumx work with adding a new column in Dealer Product table like this but the sum is destorying the numbers, even when I attempt to then divide by the rows.
I am stuck trying to combine these columns just for the calulation here

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Can you provide a pbix file , so that we can deal with your question easier ?
Best Regards,
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It has private info... is there an easy way to change values so I can share? Like a community standard or anything?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
More info:
Dealer Product table example:
Product Price example:
So I am trying to make overall2 = overall in product price table to then do my quantitiy x overall.
So in Dealer Product, it should be net = dealerProduct(quantity 50) x productPrice(overall 24) = 1,200 or if I need to make overal2 work, dealerProduct(quantity 50) x dealerProduct(overall2 24) = 1,200

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
09-09-2024 07:56 AM | |||
06-05-2024 07:33 AM | |||
07-18-2024 08:55 AM | |||
09-10-2024 05:35 AM | |||
10-03-2024 01:51 PM |