Power BI Help

Hi kinitundi ,

You can create a measure as below to get it, please find the details in the attachment.

Measure = CONCATENATEX ( VALUES ( 'Table'[Project 2] ), 'Table'[Project 2], "," )

Best Regards

Hi,

Just in case you want a Power Query solution, then this solution works

let
    Source = Excel.CurrentWorkbook(){[Name="Data"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Project", type text}, {"Project 2", type text}, {"Target Date", type date}, {"Days Count", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Project", "Days Count"}, {{"Projects", each Text.Combine([Project 2],",")}}),
    #"Pivoted Column" = Table.Pivot(Table.TransformColumnTypes(#"Grouped Rows", {{"Days Count", type text}}, "en-IN"), List.Distinct(Table.TransformColumnTypes(#"Grouped Rows", {{"Days Count", type text}}, "en-IN")[#"Days Count"]), "Days Count", "Projects")
in
    #"Pivoted Column"

Hope this helps.

Hi  kinitundi ,

Whether your problem has been resolved? If yes, could you please mark the helpful post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

Best Regards