Forum Discussion
spandy34
Responsive Resident
Responsive ResidentCONCATENATEX 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 z_Names_Matrix = CONCATENATEX( 'Name Main...
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))
spandy34Responsive Resident
Responsive ResidentHi Greg_Deckler
Thank you for your response. I get the following error when I insert DISTINCT as you suggest
Greg_Deckler
Community Champion
Community Championspandy34 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))
- spandy34
Thank you very much - that has worked. Sorry about not copying the DAX properly. I appreciate your time.