Two tables with same columns

[sid-agarwal]

1st data source in sharepoint with columns names - 

2nd data source has similar columns - 

Now, I want to make a table in PBI that shows data like this - 

Here is the relationship view if that helps.

 The two tables are not related and independent of each other so when I try to create a table in PBI like this, it does not work.
Can someone help please?
Please leave instructions in details for me to follow, I'd really appreciate it.

[v-sdhruv]

Hi @sid-agarwal ,
Since we didnt hear back from you, we would be closing this thread.
Thank you for being a part of this community.
If you still feel you need any assistance, you can raise a seperate ticket and we would be glad to assist you.
Thank you

[v-sdhruv]

Hi @sid-agarwal ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @sid-agarwal ,
Just wanted to check if you had the opportunity to review the suggestions provided?
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You

[v-sdhruv]

Hi @sid-agarwal ,

When you say you're trying to "create a table in Power BI  do you mean:

1. You're trying to combine two unrelated tables into one table visual?

If thats the case you can use Bridge table to connect these unrelated tables.
You can refer this link to follow step by step guide on how to form a bridge table.
https://www.seerinteractive.com/insights/join-many-many-power-bi
Hope this helps!
If this is not what you've been looking for, then can you be more specific about what is not working in your case and possibly provide a sample data to get more clarity so that we can help.
If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank You

[Greg_Deckler]

@sid-agarwal You can use functions like LOOKUPVALUE or MAXX(FILTER( ) ) to look up values in other tables. Otherwise, Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.