Forum Discussion

it's avatar
it
New Member
9 years ago

Relationship Query

I'm new to Power BI and trying to figure out how to utilise relationship data between 2 csv's and would appreciate it if someone here can assist.   Example: I have a CSV file with computer IP addr...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi it,

 

I agree with vanessafvg's point of view, you can take a look below formulas if it suitable for your requirement:

 

1. Table.Join function(Power query)

StepName= Table.Join(table1, key1, table2, key2, JoinKind.Inner)

 

2. NATURALINNERJOIN Function(DAX)

MergeTable= NATURALINNERJOIN(<leftJoinTable>, <rightJoinTable>)

 

 

Regards,

Xiaoxin Sheng