Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
82 | |
70 |