Forum Discussion

Iamnvt's avatar
Iamnvt
Continued Contributor
7 years ago
Solved

Concatenatex Lookupvalue multiple values

hi,   I have 2 tables: Product A B C   and Sales: ProductRegion A AA A BB B BB C AA   I need to write a calculated column that lookupvalue all the Region from...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Iamnvt 

     

    You can use CROSSFILTER function to get this column in Table1, if you have the aforesaid relationships

     

    Country =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Table3[Country] ),
        CROSSFILTER ( Table2[Region], Table3[Region], BOTH )
    ),
    [Country],
    ","
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Community Champion
7 years ago

Iamnvt 

 

Hi

 

Region_ =
CONCATENATEX (
    CALCULATETABLE (
        VALUES ( Table2[Region] ),
        Table2[Product] = EARLIER ( Table1[Product] )
    ),
    [Region],
    ","
)
  • Iamnvt's avatar
    Iamnvt
    Continued Contributor
    7 years ago

    Thanks very much

    Zubair_Muhammad  is there any ways that I can concatenatex the lookupvalue formula?

    • Iamnvt's avatar
      Iamnvt
      Continued Contributor
      7 years ago

      Zubair_Muhammad 

      what if I don't have physical relationship between the 2 tables; how can I do that?

      • Zubair_Muhammad's avatar
        Zubair_Muhammad
        Community Champion
        7 years ago

        Iamnvt 

        Actually above formula was for the case when there is no relationship.

        It is a substitute for Lookupvalue

         

        In case there is a relationship, it becomes simpler

         

        Region_ =
CONCATENATEX ( CALCULATETABLE ( VALUES ( Table2[Region] ) ), [Region], "," )