topic Re: Multiple rows into a single column with Many to Many relationship in DAX Commands and Tips

Multiple rows into a single column with Many to Many relationship

yogeshk77 — Mon, 03 Oct 2022 11:42:17 GMT

I have following tables with two level parent child hirarchy

And the output I need is a , comma separated Repo Names column in Story Table as seen below ->

Can someone please help me with a DAX query for the same?

Re: Multiple rows into a single column with Many to Many relationship

johnt75 — Mon, 03 Oct 2022 14:05:33 GMT

Try

Repos = VAR CurrentStory = Story[Story ID] VAR PRs = CALCULATETABLE ( VALUES ( 'Story PR'[PR ID] ), TREATAS ( { CurrentStory }, 'Story PR'[Story ID] ) ) RETURN CONCATENATEX ( CALCULATETABLE ( VALUES ( 'PR Repo'[Repo name] ), TREATAS ( PRs, 'PR Repo'[PR ID] ) ), 'PR Repo'[Repo name], ", " )

Re: Multiple rows into a single column with Many to Many relationship

yogeshk77 — Tue, 04 Oct 2022 04:02:41 GMT

johnt75 , you are awesome ! Thanks much