Data Modelling for Drop-Shipment Process

[TristanKuesters]

Hi all,

I didn't find a solution in my head how to modell this concept:

The business of our customers are drop shipments. So we have linked purchase and sales transaction which are linked by a order no.

There can be N purchases lines and N sales lines included.

In the purchase and/or sales lines we have dim.-keys like Material, date, customer, vendor and so on.

Additonal on each purchase and/or sales line we have measures like qty, amount and so 

The model should answer questions like:

Which vendor (names) deploy material to which customer?

Which material form the vendor side was sold as which material on the customer side...

And of course which is the margin by order..

From the measure view I find quite fast a solution with DAX (eg. calculate([amount];allexpect(orderNo)

but to get information from a dimension table like names etc (TEXT) I didn't get it.

Is there anybody helping me to point me in the right direction?

Thanks in advance.

BR, Tristan

[v-jiascu-msft]

Hi @TristanKuesters ,

Could you please mark the proper answers as solutions?

Best Regards,

[v-jiascu-msft]

Hi Tristan,

That could be because the return value could be more than one value. For example, two vendors. So you need a way to show it up as a scale value. Please try out concatenatex-function-dax.

If this doesn't help, please provide a dummy sample.

Best Regards,