Forum Discussion

juhoneyighot's avatar
juhoneyighot
Helper III
1 year ago
Solved

Concatenate rows from another table

Hello! I need help in what Dax formula to use. I have this table _Facts Company LookupAccount GL BBG BBG_84 Lumber  200100 BBG BBG_84 Lumber 506510  BBG BBG_Budz 220311 BBG ...
Tips and Tricks
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi juhoneyighot - you can use DAX with the CONCATENATEX function

     

    create dax measure to your model as below:

    GL.List =
    CONCATENATEX(
        FILTER(
            _Factt,
            _Factt[Company] = SELECTEDVALUE(Vendor[Company]) &&
            _Factt[LookupAccount] = SELECTEDVALUE(Vendor[__AccountVendorKnownAsKey])
        ),
        _Factt[GL],
        ", "
    )

     

     

     

     

    Hope this helps.

     

     

     

rajendraongole1's avatar
rajendraongole1
Super User
1 year ago

Hi juhoneyighot - you can use DAX with the CONCATENATEX function

 

create dax measure to your model as below:

GL.List =
CONCATENATEX(
    FILTER(
        _Factt,
        _Factt[Company] = SELECTEDVALUE(Vendor[Company]) &&
        _Factt[LookupAccount] = SELECTEDVALUE(Vendor[__AccountVendorKnownAsKey])
    ),
    _Factt[GL],
    ", "
)

 

 

 

 

Hope this helps.