Hello,
I have a little problem with retrieving inf from connected model.
The goal is to retrieve "Operationname" from "mrpoperation" table to "FailregistrationExport" table
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
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
