Forum Discussion

Fcoatis's avatar
Fcoatis
Post Patron
7 years ago

Contains

Hello everyone,   I need some help here: Two tables one virtual the other phisical. The virtual returns 18 names and the phisical 35 names I would lke to return A table with all 35 names and true o...
Need Help
ibarrau's avatar
ibarrau
Super User
7 years ago

Hi, I don't quite understand if you just want to check data or build a measure. Anyway, this code will return you a table with the names and the new column.

 

If the tables are related you can write this code:

EVALUATE
ADDCOLUMNS(
	SUMMARIZE( 'Phisical', ' Phisical'[Name] ),
	"NewColumnName",
	IF(
		COUNTROWS(RELATEDTABLE( 'Virtual' )) > 0,
		"True",
		"False"
	)
)

If the tables are not related, something like this should work:

EVALUATE
ADDCOLUMNS(
	SUMMARIZE( 'Phisical', 'Phisical'[name] ),
	"NewColumnName",
	IF(
		'Phisical'[name] IN VALUES ( 'Virtual'[name] ),
		"True",
		"False"
	)
)

Hope this helps

 

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