Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Relation problem

I've got 2 tables ActivityID Date EmpID EmpName 1 19-8-2020   3 Jansen 2 20-8-2020   4 de Boer 3 21-8-2020   5 Fransen   EmpID EmpName Function From To 3 Ja...
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    Would you please try the calculated column below:

     

     

    Function =
CALCULATE (
    CONCATENATEX ( VALUES ( Table2[Function] ), Table2[Function], "," ),
    FILTER (
        Table2,
        Table2[From] <= EARLIER ( 'Table'[Date] )
            && COALESCE ( Table2[To], TODAY () ) >= EARLIER ( 'Table'[Date] )
            && Table2[EmpID] = EARLIER ( 'Table'[EmpID] )
    )
)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous , I did get you to need completely.

 

Try a new column in Table 1

maxx(filter(table2, table2[From]<=Table1[Date] && coalesce(table2[From],today())>=Table1[Date] ), table2[Function])