Power Pivot - Dax Formula

[John Burkhart 3]

I have and excel power pivot were I'm trying to use the dax formula "ConcatnateEX" to turn a column of numbers into a comma separated string. My formula says it has no errors but when I go to click on it in the values field nothing happens. I need column A to be comma separated next to its companion in Column B. I think my problem is some of the numbers are converting to scientific notation. Can anyone help?

 

[alansidman]

Can you show us your DAX formula that you are using and a sample of what your source data looks like.

 

[John Burkhart 3]

Here is my formula.

 

[John Burkhart 3]

Samples of data. Mine has 21,000 + lines though

 

[John Burkhart 3]

The Cells that have an error are my problem. It's converting theses to Scientific notation. If I remove them it runs the formula perfectly.

 

[alansidman]

Creating a similar example

Book5
	A	B	C	D	E
1	Selling	Increment		Increment	Style
2	ABC	0.45		0.36	JKL, MNO
3	DEF	0.45		0.45	ABC, DEF
4	GHI	0.6		0.5	PQR, STU
5	JKL	0.36		0.6	GHI
6	MNO	0.36
7	PQR	0.5
8	STU	0.5
Sheet1