Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Create array to lookup value

Hi, I have a current table with following values: Catalogue Custom-ID Main-ID 1 895326 895326 236 895326 895326 237 895326 895326 1 895016 895016 202 895016 895016 ...
  • lbendlin's avatar
    lbendlin
    2 years ago

    like this? This is a calculated table, because you cannot use measures for lookups.

     

     

lbendlin's avatar
lbendlin
Super User
2 years ago

like this? This is a calculated table, because you cannot use measures for lookups.

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi lbendlin 

    you´re right. I have tried it with a measure, where it finally concatenated the values, but for further processing I cannot use it to lookup the value. 

    CONCATENATEX (
        DISTINCT ( Table[Main ID] ),
        Table[Main ID] & ":"
            & CONCATENATEX (
                SUMMARIZE (
                    FILTER ( Table, Table[Main ID] = EARLIER ( Table[Main ID] ) ),
                    Table[Catalogue]
                ),
                Table[Catalogue],
                ", "
            ),
        UNICHAR ( 10 )
    )
    This worked quite fine, but your solution is definitely better. Thanks a lot!