Forum Discussion
Solved
Combine Text in a Column to a Row
In a table in Power BI I have 2 columns 'Action' and 'UserName' For each 'Action' there may be one, two, ... n 'Usernames' associated to that 'Action' in successive rows. I would like to create a...
HI ghutchins
Try your measure like this:
Measure = IF( HASONEVALUE(TableName[Action]), CONCATENATEX(TableName,TableName[UserName],", "), BLANK() )Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
HI ghutchins
Try your measure like this:
Measure =
IF(
HASONEVALUE(TableName[Action]),
CONCATENATEX(TableName,TableName[UserName],", "),
BLANK()
)
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
Thank you Mikelytics ! Just the ticket!
