PowerBI Joining UnRelated Tables

[sstrachan]

I have two tables in Power BI. I need to return the value from one table based on the the date range and employee_id of the original table. Can anyone assist me in how to do this? the Hierarchy_ID changes from Month to Month and is unique to the Employee_ID. I need to use the Employee_ID look at the Entry_Date and determine the Hierarchy_ID based on the start/end date of the Employee_ID. Below is an example of what I'm trying to accomplish:

Any assistance is appreciated.


Thanks

 

[Matt Allington]

I wrote an article a few weeks ago that should help you

How Many Employees by Period

I have many reasons for sharing content online. The main reasons are that I like sharing what I know, but also that I want to document how to complete a task for future reference. My article today ticks both of those boxes. How Many Employees by Period I’m calling this [...]Read More »

exceleratorbi.com.au