Forum Discussion
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.
Yes my first try was to use matrix but the matrix becomes to big, more than 100 columns for different values of "A" when I for example choose a whole month, not just two days like in the example here above
Hi hlynurgudna ,
Believe that you issue is regarding the A column where you have all those different values. What is the exact purpose of the presentation is to summarize the values that match into a single row?
Exactly, to show the values that match into a single row.
I know that the problem here is that I have all these different values in column A, so I was thinking if it would be possible to create a measure that combines/groups all the letter codes when B and Date matches and use that as a valueHi hlynurgudna ,
You can do this using the CONCATANEX formula of dax that allows to make a concatenation of values in a column.