Let’s say that I have two tables. One, with dates and the same variable by a series of countries. The second one has a Country field and a series of dates referred to the same event. What I want is to define a formula for Cases By Event date in which column of first table is referred by the value of column Country of table 2 at every row. Something like Cases.Filter(Date=thisRow.[Event A]).ESP
but, instead of ESP, of course, some identification between a specific column of first table and ThisRow.Country
. I haven’t been able to find any call to column name useful for point to the column I need
Any help would be really appreciated
The doc: