Forum Discussion

ccolletti's avatar
ccolletti
Helper I
3 years ago

Combining Data, Separated by a Comma when Matching value in One Column in Power BI Desktop

Hi All,   I'm working on building a rollup of data to match Vendors to the State and Store numbers they work in. I was able to pull this data in Excel using TextJoin, but I want to utilize Power BI...
Need Help
sevenhills's avatar
sevenhills
Super User
3 years ago

Two approaches, you can decided based on your needs.

 

1) Create new DAX table

2) Creating measures in the same table

 

New Table using DAX:

Table52Vendor_Rollup = 
    Summarize(
        Table52Vendor, Table52Vendor[Vendor], 
           "States", CONCATENATEX(DISTINCT(Table52Vendor[State]), Table52Vendor[State], ", "),
           "Stores", CONCATENATEX(DISTINCT(Table52Vendor[Store]), Table52Vendor[Store], ", ")
    )

 

New Measure within the table

Vendor States = CONCATENATEX(DISTINCT(Table52Vendor[State]), [State], ", ")

Vendor Stores = CONCATENATEX(DISTINCT(Table52Vendor[Store]), [Store], ", ")