Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Return value based on matching value & Date difference

Hello,   Having an issue figuring out how to gather information from a seperate table comparing two different columns. Below are examples of tables. Case Table holds all cases with the date the cas...
  • az38's avatar
    az38
    6 years ago

    Hi Anonymous 

    try this calculated column

    Department = lookupvalue(DepartmentTable[Current Department];DepartmentTable[Employee Email];[Email];DepartmentTable[Job Date];calculate(max(DepartmentTable[Job Date]);filter(all(DepartmentTable);DepartmentTable[Employee Email]=[Email] && DepartmentTable[Job Date]<=[Date Created])))

    do not hesitate to give a kudo to useful posts and mark solutions as solution

     

bwarner87's avatar
bwarner87
Advocate I
4 years ago

this worked like a charm for me! thank you!