locked
look up from not related table RRS feed

  • Question

  • Hi All

    What I need is to have a calculated column formula with the results as in a Table 1. (Calculated Column)

    Results are MAX (Table 2. (Day))

    Results are manually filled up, but in case of thousand of rows it is not possible.

    Table 1. and Table 2. are not related one. But even if I relate them using addtitional table without duplicates i still can not look up properly. I have tried RELATED but it was not work.

    How the calculated table formula should look like?

    Table 1.

    Week             Produkt                             Calculated column

    1                          A                             new formula (result should be 3)

    1                          B                             new formula (result should be 3)

    2                          c                               new formula (result should be 2)

    3                          A                               new formula (result should be 5)

    Table 2.

    Week              Day

    1                       1

    1                       2

    1                       3

    2                       2

    3                       3

    3                       5

    Monday, July 28, 2014 3:18 PM

Answers

  • Gordonik,

    Maybe something like this.

    =MAXX(FILTER(Table2, Table1[Week] = Table2[Week]), Table2[Day])

    Hope this helps

    Reeves


    Denver, CO

    Monday, July 28, 2014 3:30 PM

All replies

  • Gordonik,

    Maybe something like this.

    =MAXX(FILTER(Table2, Table1[Week] = Table2[Week]), Table2[Day])

    Hope this helps

    Reeves


    Denver, CO

    Monday, July 28, 2014 3:30 PM
  • Thanks very much Reeves

    It's working! :)

    G.

    Tuesday, July 29, 2014 8:17 AM