PowerBI Joining UnRelated Tables

You should not post the same question in 2 separate forums. 

ss8551 

It does work on the data you have shared (see attached file)

The error you are getting means there is more than one hierarchy for the given date and employee. So you should either:

1) solve the issue on the data or

2) define a criterion to select which of the matching hierarchies you want

If you go for 2), you'll have to update the code to implement this. For instance if you want to keep the largest one:

Hierarchy_ID =
VAR entryDate_ = Order_Table[Entry_Date]
VAR employeeID_= Order_Table[Employee_ID]
RETURN
    CALCULATE (
        MAX ( Hierarchy_Table[Hierarchy_ID] ),
        Hierarchy_Table[Employee_ID] = employeeID_,
        Hierarchy_Table[Start_Date] <= entryDate_,
        Hierarchy_Table[End_Date] >= entryDate_
    )

ss8551 

You're welcome

You have marked the wrong post as solution. Can you update this?