Grouping into single Row

[damit23183]

Hi,

I need some help in DAX logic on how would covert same multiple rows into one. 

I have set up like this;

As Result, I would like to have this,

Thank you in advance. Any suggestion or advise would be appreciate it.

NOTE: This is just example data, there are more than 50 columns like this in actual data source.

Thanks

[v-prasare]

Hi @damit23183,

Thanks for letting us know that your issue got resolved, please do let us know if you still got any questions. If we don’t hear back, we’ll go ahead and close this thread. For any further discussions or questions, please start a new thread in the Microsoft Fabric Community Forum we’ll be happy to assist.
Thank you for being part of the Microsoft Fabric Community.

[v-prasare]

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.

@Greg_Deckler, Thanks for your prompt response

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are

[Greg_Deckler]

@damit23183 Sure, create a measure as follows:

Account Number Measure = CONCATENATEX( 'Table', [Account Number], ", " )

Put that in a table visual along with ID, FIrst Name and Last Name columns.

[damit230183 · Accepted solution]

Thank you for responding. It's worked as expected.