Forum Discussion
Solved
DAX to de-duplicate text string?
Would it be possible to get DAX de-duplicating a text string? In the example below - or any suggestions on alternate ways, but still using DAX 🙂 thanks in advance Address Area Distributio...
Try this.DeDuplicatedString =
CALCULATE(
CONCATENATEX(
VALUES('Table'[Area]), -- <-- this removes duplicates
'Table'[Area],
"; ",
'Table'[Area]
),
ALLEXCEPT('Table', 'Table'[Addr
ess])
)
Chanty4u is right. You can also only use
String =
CONCATENATEX(
VALUES('Table'[Area]), -- <-- this removes duplicates
'Table'[Area],
"; ",
'Table'[Area]
If u only us the adres