Hi,

I’m after some help please on this basic model.

Please find attached, screenshots of the whole Data Model (Excel)

I use Excel at Work initially then drop into Power BI afterwards (Work does support BI yet)

Raw Data set is from SAP

Material Units Receipted into the Warehouse in bulk units

The same material bulk units are then split over several Van orders (Tran)

Ideally the figures for each should balance unless an error in receipting is made.

That is the KPI that I wish to capture:

Is there a loss (Difference) on a Material Line and which Operative Receipted the Material?

The numbers look good until I add in the Operatives name as a field to the Power Pivot

As soon as the Operative field is added in the numbers don’t make sense, my relationship must be incorrect?

Can anyone help please.

Excel Data Model File - Google Drive Link Below

Thanks

Darren