Forum Discussion
Add row from table to another table based on value
Hi all,
Just a quick question -
I have some tables in BI being populated by SharePoint. This SP lists are updated via PowerApps. There are some rows of Table #1 that I would like to put in Table #2 depending on the value of Table #1's "Title" column.
If the title contains two specific characters at the beginning, I would like to add this row into Table #2. These tables share some similar columns, but they are not identical tables. I'd like to be able to pick and choose what content of the row gets populated into the second table.
Is this possible?
Thanks,
Farhan
2 Replies
Refer if these two links can help
https://radacad.com/append-vs-merge-in-power-bi-and-power-query
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Using M in Query editor you should able to do it in a better manner.
In Dax, if you want to copy one from table to table one based on some condition/s. You can do like
Get from Table 2
New Column = maxx(filter(table2,table2[Col1]= table1[col1] && table2[Col2]= table1[col2] ),table2[required_col])Find and search function can help you get partial match.
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601Hi , farhandsome
According to you description ,you need to model the data in Powerquery .
Maybe you will use “merge” or “append” to combine your data.
For more details ,you can refer to following article and video:
URL:https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
URL: https://www.youtube.com/watch?v=qXH4WjCykLc
If it doesn't meet your requirement, kindly share your sample data and expected result if you don't have any Confidential Information.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
