Forum Discussion

Ronald123's avatar
Ronald123
Icon for Resolver III rankResolver III
8 years ago
Solved

Date before from another table

  Hello,   Can someone help me with this? I have two table without any relationsship. I need a calculated colum in the PayTable from the CallsTable. The calculation rule is the first date f...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi Ronald123,

     

    To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.

     

    Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Icon for Community Support rankCommunity Support
8 years ago

Hi Ronald123,

 

To be general, are date in column Table Calls[CallDate] unique? To use lookupvalue(), or other similar function like related(), you should build a one-many relationship between the two tables, then use column in one-side as a filter condition to achieve the value you want.

 

Regards,

Jimmy Tao