Forum Discussion
Use all data from drillthrough table to populate new table
I have a 3 page power bi report. First page selects a profile that has a list of 1000 accounts.
Table layout
Column 1 = Customer Name
Column 2 = Customer Product
Column 3 = Customer Address
This drillthroughs to another page where I can cut down that 1000 account list to a smaller subsegment that has a specific product I want to focus on.
Now that i have my table on my third page with just my list of say 150 accounts with the specific product, I want to then pull in all products that those accounts have. Idealy I want to use all of the account names from column 1 to filter back against the original 1000 record table and pull in all lines where that customer name is listed.
Hopefully this makes sense and I can be pointed in the right direction!
Hi 94gjcb ,
You could create a a new column in table 1:
maxx(filter(Table2,Table2[ColumnA] = table1[ColumnA]), Table2[ColumnB])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Similar question refer:
https://community.powerbi.com/t5/Desktop/Populate-table-1-with-data-from-table-2/m-p/1862544
Best Regards
Lucien
1 Reply
- v-luwang-msftCommunity Support
Hi 94gjcb ,
You could create a a new column in table 1:
maxx(filter(Table2,Table2[ColumnA] = table1[ColumnA]), Table2[ColumnB])
refer 4 ways to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8Similar question refer:
https://community.powerbi.com/t5/Desktop/Populate-table-1-with-data-from-table-2/m-p/1862544
Best Regards
Lucien