Forum Discussion
CONCATENATEX MATRIX NO DUPLICATES
Hello
I have the following matrix where the Rows are the Mission Project Field, the column is the Row field and the Values is the following DAX
@amitchandak @tamerj1 @danextian @goncalogeraldes @v-tangjie-msft @v-kaiyue-msft @Uzi2019
spandy34 You didn't use my code. Your code has syntax errors and will not work because it is not the correct logic. Use exactly this:
z_Names_Matrix = CONCATENATEX( DISTINCT( 'Name Main'[Name] ) , [Name], "," & UNICHAR(10))
4 Replies
spandy34 Try:
z_Names_Matrix = CONCATENATEX( DISTINCT('Name Main'[Name]),[Name],"," & UNICHAR(10))Hi Greg_Deckler
Thank you for your response. I get the following error when I insert DISTINCT as you suggest
spandy34 You didn't use my code. Your code has syntax errors and will not work because it is not the correct logic. Use exactly this:
z_Names_Matrix = CONCATENATEX( DISTINCT( 'Name Main'[Name] ) , [Name], "," & UNICHAR(10))
