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

     

az38's avatar
az38
Community Champion
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

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi az38 

That worked perfect! Originally tried using Lookupvalue, but had no luck. Thank you!