Forum Discussion

juhoneyighot's avatar
juhoneyighot
Icon for Helper III rankHelper 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.

     

     

     

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Icon for Super User rankSuper User
1 year ago

Hi juhoneyighot ,

Try the bellow DAX measure:

GL.List = 
CONCATENATEX(
    FILTER(
        _Facts,
        _Facts[Company] = Vendor3[Company] &&
        _Facts[LookupAccount] = Vendor3[__AccountVendorKnownAsKey]
    ),
    _Facts[GL],
    ","
)