Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Been looking online for ways to lookup the value between start and end dates and position and can't seem to figure it out
I have 2 tables, a 'Person' table that shows when the employee was hired and quit (however, the employee can quit and come back) and another table 'Position' which shows the position the person was in in a specified time range.
Trying to get the format in the last output in the screenshot below and been experiementing with LOOKUP Values and can't seem to get it correct.
Solved! Go to Solution.
Hi @ARomain
Please use Power query merge table option to merge these two tables. While merging tables, select Name and Positon start key to match the person table. Refer below images
Hi @ARomain
Please use Power query merge table option to merge these two tables. While merging tables, select Name and Positon start key to match the person table. Refer below images
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |