Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
How can I concatenate the result of VALUES([Column]) in a single text comma separated?
Thanks
Solved! Go to Solution.
Use CONCATENATEX
Ok. Yesterday, I was using CONCATENATEX badly I think.
Syntax is
CONCATENATEX(<table>, <expression>, [delimiter])
I was using the entire table in <table> and VALUES([column]) in <expression> and it doesn't work.
Now, I tried using VALUES([column]) in <table> and the [column] itself in expression and it works:
Measure = CONCATENATEX(VALUES(Table[column]);Table[column];", ")
Thanks for putting me on the way.
Regards
Use CONCATENATEX
Ok. Yesterday, I was using CONCATENATEX badly I think.
Syntax is
CONCATENATEX(<table>, <expression>, [delimiter])
I was using the entire table in <table> and VALUES([column]) in <expression> and it doesn't work.
Now, I tried using VALUES([column]) in <table> and the [column] itself in expression and it works:
Measure = CONCATENATEX(VALUES(Table[column]);Table[column];", ")
Thanks for putting me on the way.
Regards
Cool, glad you got there!
@Greg_Deckler@javi0unavailabl I've also used
Measure = CONCATENATEX(Table,Table[column],", ")
But getting the same result as above.
Hi @Greg_Deckler @javi0unavailabl Is there a way to do this for all values in a column. If I have column values [1,2,2,3,3], I should get 1,2,2,3,3 as the result. When I use the formula in the solution above, I get 1,2,3 as the result.
Thanks in Advance.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |