Forum Discussion
Getting data from 2 different tables to create a new table
Hey bishnu ,
create a pbix file that contains sample data, but still reflects your data model (tables, relationships, calcualted columns, and measures). Upload the pbix to onedrive, googledrive, or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method share the xlsx as well.
Explain the expected result based on the sample you provide.
What I'm missing is the explanation on how you merged the content from column Document and Progrss, next, the source of the column ID, either it's from table A or B, provide the source.
Regards,
Tom
Hello Tom
I am adding the wetransfer link to powerbi file
As mentioned in the previous table, I am taking data from two tables to create the third table.
The problem is that since the "system" column data viz. BMS 1, BMS 2, and BMS 3 are repetitive (3 instances) in the first table A,
It is repeated in 3 instances in the third table D (in the power bi file).
Instead, I just want one instance of BMS 1, BMS 2, and BMS 3 in the third table as in table B.
Thanks a lot Ashish. it works
You are welcome.
Hello Tom
no worries. Thanks a lot for swift response.