Forum Discussion

KatkaS's avatar
KatkaS
Post Patron
6 years ago
Solved

Not returning the value..

Hello, I'm wondering if someone could help me with following..   I created new column in Data tab to return a value from another excel sheet, but the values are not returned... No error is indica...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    It seems like coming from the same sheet not different. and You compared [FAM], which I do not see in this table.

     

    This how we get from another table

    New Column = sumx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

     

    same table

    New Column = maxx(filter(table1,table1[Col1]= earlier(table1[col1]) && table1[Col1]= earlier(table1[col2]) ),table1[required_col])

     

    Condition can change as per need

     

amitchandak's avatar
amitchandak
Super User
6 years ago

It seems like coming from the same sheet not different. and You compared [FAM], which I do not see in this table.

 

This how we get from another table

New Column = sumx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])

 

same table

New Column = maxx(filter(table1,table1[Col1]= earlier(table1[col1]) && table1[Col1]= earlier(table1[col2]) ),table1[required_col])

 

Condition can change as per need

 

  • KatkaS's avatar
    KatkaS
    Post Patron
    6 years ago

    Thank you, Amit!!! I had to add another condition for Period, but the logic you desribed worked very well.