Forum Discussion
Merge vs Relationship
Hello PBI community! I have two tables, Table A is an inventory table with a column for IP address and Network name. The Table B contains a column for IP address, CVE number and Severity. Table ...
Hi ryan_telstra ,
If i understand you correctly, you can use Query Editor->Merge Queries as New and Left outer join to combine your tables. Please see the below screenshot:
Measure is also a choice and you can use filter() function or If() function to filter what you want.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.