Forum Discussion

amoshier's avatar
amoshier
New Member
2 years ago

Subnets we are not using

Sorry but i'm not even sure how to start...  I want to find out what subnets we are not using.   As an example see below.   We have some subnets that we are using and the whole /24 of what would be availble.   Now I want to know what is left from the /24 that we are not using.   

 

 

Any suggestions would be appreciated! 

 

Using

Owned

 

Need Help

3 Replies

    • amoshier's avatar
      amoshier
      New Member
      2 years ago

      I'm sure the use of this will expand... But my current plans are one a nice design with all our subents by VLAN.  But I would also like a report by VLAN of what subnets are not in use.  So If i'm looking at the example I gave above I own 10.1.10.0/24 (Owned) but i'm only subents i'm currently using are listed in the other table(Using).   I want to know what subnets I have availble/have not used.  

      It should tell me that I have not used 10.1.10.64/27

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi amoshier 

     

    Maybe you can try Except() function:

    Here is a sample:

    Then i add a new table:

    Table 2 =
EXCEPT (
    SELECTCOLUMNS ( 'Table', "Owned", 'Table'[AA] ),
    SELECTCOLUMNS ( 'Table (2)', "All", 'Table (2)'[BB] )
)

    This dax can remove duplicate values from the second table and the first table, so the result is as follow:

    Here is the link for your reference:

    EXCEPT function (DAX) - DAX | Microsoft Learn

     

    If the above one can't help you, could you please provide more raw data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples? It would be helpful to find out the solution. You can refer the following links to share the required info:

    How to provide sample data in the Power BI Forum

    How to Get Your Question Answered Quickly

    And It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

    How to upload PBI in Community

    Best Regards

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