Self Join in power Bi

[PBILover]

Hi,

I have cosmos DB data where data is in different document formats. I want to use the column of the main document to connect another document from the same container in a power BI .

For e.g. 

one document has fields like id, Partition key, col1,col2 ....

another document has fields like id,partition Key,col1,col2 etc.

I want to have a separate table where the document1.partition key  = Document2.PartitionKey2

will it be possible?

this should be done in power query editor

Thank you

[V-lianl-msft · Accepted solution]

Hi @PBILover ,

Extract document1.partition key column as a table, and then create a function and invoke it. You can refer to this blog:

https://community.powerbi.com/t5/Community-Blog/Use-Column-as-Parameter-for-Custom-Function-in-Power... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@PBILover , if you want to create a hierarchy and use

https://radacad.com/parsing-organizational-hierarchy-or-chart-of-accounts-in-power-bi-with-parent-ch...

Other wise you have duplicate the tables and create join