Trying to link offers to orders without direct relationship

R__J — Mon, 03 Apr 2023 15:34:34 GMT

Hi all,

I am not able to find an answer on the following problem i am facing.

The model has a customer table, offer table, offer items and quantity table
Then i also have an order table with an items and quantity table.

Offer is linked to customer and so is the order. Offer item is linked to offer and order item is linked to order.

There is no link between order and offer, a customer can make one order combining multiple offers.

What i try to achieve is per customer to check the offers

During this check i need to check per item the amount that was offered and compare this to orders made by the same customer.

So all offered items combined and compare to all ordered items combine for this customer (could be a positive or negative delta).

The outcome should be a Order equal offer Order not equal offer.

There is no option to link orders and offers directly then via customer. Solution can be a calculated column to any of the tables or a dax measure

Below should give a Customer 1 All Ordered, Customer 2 not all ordered

My setup is the following.

I have a table with all Offers with a related table of all individual items of the offer.

the order part is

Any ideas

Thanks

Re: Trying to link offers to orders without direct relationship

lbendlin — Wed, 05 Apr 2023 00:00:19 GMT

Is the offer name correlated to the order name?

R__J — Wed, 05 Apr 2023 06:22:11 GMT

that was my mistake. Order and offer Names are not related and can be anything typed in by a user

thx

lbendlin — Wed, 05 Apr 2023 11:29:56 GMT

Does your real data contain timestamps? Are you trying to show this by a certain period?