Forum Discussion

it's avatar
it
New Member
9 years ago
Solved

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
    9 years ago

    A really quick solution would be a calculated column in your computer table:

     

    Subnet = LEFT([IP], 5) & ".0.0/24")

     

     

    Now go to your table relationships tab and link your computers to your locations via the subnet.

     

    Now add the matrix visual to your reports and you'll see if you list the computers, then if you bring in your Office field from your office list, it will correctly show.

it's avatar
it
New Member
9 years ago

Hi smoupre

 

Thanks for your reply.

Example: 

 

OfficeSubnet
NSW10.10.0.0/24
QLD10.20.0.0/24
VIC10.30.0.0/24

 

DescriptionSerialIP
Desktop1234N12310.20.0.50
Laptop2345M67810.10.0.108
Server3456O78910.30.0.167

 

So what I would like to achieve as an end result is link both tables in 2 different CSV files together and have Power BI show the following table based by the IP in the second table and automatically populate the Office from the first table. Hope i'm making sense :)

 

DescriptionSerialIPOffice
Desktop1234N12310.20.0.50 
Laptop2345M67810.10.0.108 
Server3456O78910.30.0.167 
Anonymous's avatar
Anonymous
Not applicable
9 years ago

A really quick solution would be a calculated column in your computer table:

 

Subnet = LEFT([IP], 5) & ".0.0/24")

 

 

Now go to your table relationships tab and link your computers to your locations via the subnet.

 

Now add the matrix visual to your reports and you'll see if you list the computers, then if you bring in your Office field from your office list, it will correctly show.