Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Compare Key and column from another table

Hello,

 

I have a table that is my list of weeks and their corresponding week end (ie 1 with 11/9/19, 2 with 11/16/19). I have a table that has a column using the list of weeks. I want to compare these two, and if the values are equal for the second table to have the week end date. 

 

I've tried using an if statement but that's restricted to working in the same table. 

Need Help
  • parry2k's avatar
    parry2k
    6 years ago

    Anonymous can you share your relationship. is 2nd table on many side of the relationship? If yes then you can add new column in your 2nd table like this

     

    Week End Date=
RELATED( FirstTable[Week End Date] )

     

1 Reply

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous can you share your relationship. is 2nd table on many side of the relationship? If yes then you can add new column in your 2nd table like this

     

    Week End Date=
RELATED( FirstTable[Week End Date] )