HOW I WILL ACHIEVE THIS REQUIREMENT BY USING DAX

[suparnababu8]

Hi,

This is input..

 and

i want output like mentioned below

 can any one help me , how i will achieve this requirement by using DAX.

Thanks in advance.

[Greg_Deckler · Accepted solution]

@suparnababu8 You can do this: 

vaccine measure = CONCATENATEX( 'Table', [Vaccine], "," )

or

vaccine table = SUMMARIZE('Table', [Name], "vaccine", CONCATENATEX( 'Table', [Vaccine], "," ) )