Forum Discussion
Adding a Column from a different table to a calculated table
Anonymous this is what you need:
Missing From CMDB = SELECTCOLUMNS ( CALCULATETABLE ( IT_Current, EXCEPT ( VALUES ( IT_Current[IP_ADDRESS_RAPID7] ), VALUES ( CMDB_Active[IP_Address] ) ) ), "IP_Address_Rapid7", IT_Current[IP_ADDRESS_RAPID7], "Host_Name", IT_Current[Host_Name] )the same will apply to the 2nd table.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Super UserAnonymous this is what you need:
Missing From CMDB =
SELECTCOLUMNS (
CALCULATETABLE (
IT_Current,
EXCEPT ( VALUES ( IT_Current[IP_ADDRESS_RAPID7] ), VALUES ( CMDB_Active[IP_Address] ) )
),
"IP_Address_Rapid7", IT_Current[IP_ADDRESS_RAPID7],
"Host_Name", IT_Current[Host_Name]
)
the same will apply to the 2nd table.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.
Thanks so much for the help!
It looks like it worked for "Assets in CMDB Missing from Rapid7" table!
It did come back with this error on the Missing From CMDB table:
<ccon>The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.</ccon>