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 t...
  • parry2k's avatar
    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] )