Data modelling problem

[Anonymous]

Hello, 

I have a little problem with retrieving inf from connected model.

The goal is to retrieve "Operationname" from "mrpoperation" table to "FailregistrationExport" table

test.pbix

By default MRPTable_DAT will be having many antries( Only test file is having many-to-one relation). Test file has one unique orders, but its a straight fact table

[Anonymous]

If someone will have any idead how to solve it by modeling let me now.

For now i used merge with 2 selections with success

[Anonymous]

It wont work cause of indicrect relation, many to many . The file i attached has default reliationships with clean power query function

Table work across relationship as production no as id to retrieve Op name for "OperationNo"

FailRegistration>

>MRPtable_dat>

>MRPRoute>

>MRPOperation

After few modification of power query. The table cant display right now the data i m adding from Failregistrtation and MRPoperation

[HoangHugo]

Hi, try to active (x) relation