Forum Discussion

Frequent Visitor

3 years ago

Solved

Create String based on results in table in report

Dear, I have a report with multiple slicers and a results table. The results in the table are determined by the slicers. I would like to create a string to be presented in the report, composed...

Ritaf1983
3 years ago
Hi Mants
You can use concantenatex formula to achieve it.
Create a measure with code :
test = CONCATENATEX(VALUES('Table'[ProjectCode]),[ProjectCode],",")
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Icon for Super User rank

Super User

3 years ago

Hi Mants
You can use concantenatex formula to achieve it.
Create a measure with code :

test = CONCATENATEX(VALUES('Table'[ProjectCode]),[ProjectCode],",")

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.