Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
PetrK
Helper II
Helper II

Combine all result if Lookupvalue to one

Hi all, please for help.

I have two tables,
table A

PetrK_0-1712655408762.png

 

Table B

PetrK_1-1712655447696.png

 


I'm looking for formula which will for each Product in Table A find all projects in Table B a put them to column "used in project" as you can see in result Table A

result Table A

PetrK_2-1712655466795.png

 

Thank you for help

 

1 ACCEPTED SOLUTION

you can also try this

Column = CONCATENATEX(RELATEDTABLE('Table B'),'Table B'[project],",")
12.PNG
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
ryan_mayu
Super User
Super User

@PetrK 

you can create a measure

 

Measure = CONCATENATEX('Table B','Table B'[project],",")
 
and so item with no data
11.png
13.PNG
 
or you can do merge tables in PQ
11.png
 
 
then group by
 
= Table.Group(#"Changed Type", {"product used in project"}, {{"project", each Text.Combine([project],","), type nullable number}})
 
12.PNG
 
pls see the attachment below




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




thank you,
at real table A and B are much more comlex and PQ cant be used because some important columns are add/modified by dax formulas.
And I need get used projects to table A column, because reasult will be used in slicer. 

you can also try this

Column = CONCATENATEX(RELATEDTABLE('Table B'),'Table B'[project],",")
12.PNG
 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.