Forum Discussion

Microsoft Employee

9 years ago

Solved

Concatenatex with Distinct column values

Hi, I am summarizing data from one table into another. Part of the data in the original table is a column of type text which I generate a comma delimited summary string. Issues = var ft = ...

CONCATENATEX

DAX

markdy
8 years ago
Hey There bugs84,

I think this might help:

ListProductTypes = CALCULATE(CONCATENATEX(VALUES('Table'[ProductType]),'Table'[ProductType],","))

Credit Goes to Data and Analytics with Dustin Ryan:
https://sqldusty.com/2016/06/29/5-more-power-bi-tips/

According to Dusting Ryan:
Cited References:
Dustin, Ryan. 5 More PowerBI Tips. Data and Analytics with Dustin Ryan, 2016. Web. 17 January 2018.