Forum Discussion
How to Get Your Question Answered Quickly
Ever wonder why some questions get answered so quickly while others languish or are seemingly completely ignored? Fear not, this article will help guide you into getting your question answered quickl...
Hi Team,
I have two tabes in Power BI 1.) Work Location Table with Date and Employee Code 2.) Employee Transfer Table with Employee Code , Work location, From Date and To Date. I would like to get the work location code in the table 1 ( Work Location Table) as i have shown below. Can you please help me out.
| Work Location Table 1 | ||
| Date | Employee Code | Work Location Code |
| 23-May-23 | 20593 | |
| 22-May-23 | 20593 | |
| 21-May-23 | 20593 | |
| 20-May-23 | 20593 | |
| 19-May-23 | 20593 | |
| 18-May-23 | 20593 | |
| 17-May-23 | 20593 | |
| 16-May-23 | 20593 | |
| 15-May-23 | 20593 | |
| 14-May-23 | 20593 | |
| 13-May-23 | 20593 | |
| 12-May-23 | 20593 | |
| 11-May-23 | 20593 | |
| 10-May-23 | 20593 |
| Employee Transfer Table 2 | |||
| Employee Code | Work Location Code | From Date | To Date |
| 20593 | DM | 1-May-23 | 15-May-23 |
| 20593 | MOE | 16-May-23 | 17-May-23 |
| 20593 | MICC | 18-May-23 | |
| Work Location Table Result | Work Location Code | ||
| Date | Employee Code | MICC | |
| 23-May-23 | 20593 | MICC | |
| 22-May-23 | 20593 | MICC | |
| 21-May-23 | 20593 | MICC | |
| 20-May-23 | 20593 | MICC | |
| 19-May-23 | 20593 | MICC | |
| 18-May-23 | 20593 | MOE | |
| 17-May-23 | 20593 | MOE | |
| 16-May-23 | 20593 | DM | |
| 15-May-23 | 20593 | DM | |
| 14-May-23 | 20593 | DM | |
| 13-May-23 | 20593 | DM | |
| 12-May-23 | 20593 | DM | |
| 11-May-23 | 20593 | DM | |
| 10-May-23 | 20593 | DM |