Table with text measures

Hi,

to obtain this

you have to group by

in the formula bar you obtain this row

= Table.Group(#"Changed Type", {"Merged", "B"}, {{"Count", each _, type table [Merged=nullable date, A=nullable text, B=nullable text]}})

You modify it this way

= Table.Group(#"Changed Type", {"Merged", "B"}, {{"Count", each [A], type list }})

at this point by clicking on Count

Expand to new rows

then split your Count column by delimiter

change the name of the columns 

and it is done

If this post is useful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

Hi hlynurgudna ,

You can do this using the CONCATANEX formula of dax that allows to make a concatenation of values in a column.