Forum Discussion
Lookup Table change with time
Excuse my title, as I wasnt sure what to name this topic. I have a lookup table that uses an employee number to tell what budget group someone is in. One of the employees here is moving to a differen...
I'm going to bump this up because I am still trying to work up a viable solution. The propblem is that I need an empoyees information to be accurate by the month. I am not proficient with DAX and when I went over this with Parry2k he said that is what I'll need. Looking for thoughts or ideas on how to proceed. Thank you!
Bump
- ChrisMendoza
Resident Rockstar
Anonymous -
Does your organization not utilize an additional Position_Code or similar to make a unique key on EmplID?
0001 is John's EmplID
00010 is John's "1st position"
00011 is John's "2nd position"
If not, you could create this artificially then flag 00010 as inactive retaining those records and 00011 as active.
My organization does identify EmplID & Position_Code; this is my Key that is used for uniqueness.
