Forum Discussion
Join multiple rows, sum a column and join another column
Dear all, i have a table like this one: id field1 field2 spent project 123 a b 1 myprj 123 a c 3 techprj 456 z s 2 newp 789 w a 5 greenPrj What i need is a DAX...
amitchandak
Super User
Super Userauron , If you want measures
max(Table[field2])
sum(Table[spent])
and
concatenatex(Table, Table[project], ", ")
refer more options
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24