Forum Discussion
Conditional Column from Two Different Tables
I have two tables. Table A - A list of all locations that have ever existed and the data related to that location. Table B - A list of all locations that have ever existed, with a column on the c...
Anonymous
It seems they are related by the sites and restaurant, you could create the expected table with this formula:
Table = CALCULATETABLE(VALUES('Table A'),FILTER('Table B',[Wan_Status]<>"Closed"))
Paul Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.