Forum Discussion
Alternative Calculated Column
Hi Guys, I have 2 Datasets, whose sample is provided below i am trying to create a calculated column in table1, looking for Country from Table 2, if there are multiple valu...
Anonymous , create a new column in Table
new column =
var _min = minx(filter(Table2,table2[email] =table[email] ), table2[date])
return
minx(filter(Table2,table2[email] =table[email] && Table2[Date]=_min), table2[Country])
Works!!
Thank you amitchandak 🙂