Forum Discussion
massotebernoull
Helper I
Helper ICreating a column with two tables (one with repeated values)
Hello guys, I Have two tables, Table 1 with main data (dimension table), and Table 2 with repeated values (fact): Table 1 ITEM OTHER data... A B C D E F ...
Hi,
This calculated column formula works
=if(CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[ITEM]=EARLIER(Table1[ITEM])))>=1,"Already made contact","No contact")Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
This calculated column formula works
=if(CALCULATE(COUNTROWS(Table2),FILTER(Table2,Table2[ITEM]=EARLIER(Table1[ITEM])))>=1,"Already made contact","No contact")
Hope this helps.