Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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 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

Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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