Concatenate column values

Power BI Paginated Reports
1

Hi @Sam,
I’m juggling with Report Builder and I need to build a string composed by the concatenation of values of in a column. In the example attached Concatenate.rdl (11.3 KB)

I have values from A to F and the result should be A, B, C, D, E, F

image

I’m trying to use the Join function which should do the trick but I always get an #Error.

=Join(Fields!Class.Value, “,”)

Why is that? What I’m doing wrong?

Thanks for help

Roberto

2

Bumping this post for more visibility from our experts and users.

3

Hi @Sue - Can you help with Paginated question.

Thanks
Ankit J

4

Hi Roberto, I haven’t had to use this before, however I think the problem is that you need to iterate over the Class.Value column to gather all the values before you can then join.
Have a look at this post and this may help you

Let me know how you get on and if that doesn’t work, we can have another look,
Sue

1 Like