Alternative Calculated Column

[Anonymous]

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 values expected, it should return country with earliest  Date

I have created the column with following dax 

Lookup_Country =

Var Date1 = CALCULATE(MIN('Table (2)'[Date]))

Return

CALCULATE(VALUES('Table (2)'[Country]),FILTER('Table (2)','Table (2)'[Email]='Table'[Email] && 'Table (2)'[Date]=Date1))

it is returning correct values as this

Name   Email      Country
A          Email1    AU
B          Email2    AQ
C          Email3    AW

A          Email4    AD
B          Email5    AS


However my original dataset is much larger and when i am applying this calculated column, i am getting error as

"There isnt enough memory to complete this Operation, please try again later"

Is there any other Dax functions i can use to get the above lookup values?
Please suggest

[Anonymous]

Works!!
Thank you @amitchandak  🙂

[amitchandak · Accepted solution]

@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])