DAX Issues

[nirvana_moksh]

Hey All,

I am trying to using EVALUATE (or anything better) table function in DAX and it keeps giving me a error (red line under EVALUATE).

1. I have two Table's - Table 1 and Table 2. Table 1 has all ID's that I want in the resulting final table and everything else from Table 2
2. Table 2 is a DAX Generated Table so I cannot use Power Query Merge option since it does not show up there, if it did I was golden

I am trying to achieve the below:

TABLE 1 WITH ALL ID'S - 

TABLE 1 ID	COLUMN1	COLUMN2	COLUMN3	COLUMN4	COLUMN5
1	X	AB	TT	YY	IYT
2	Y	BC	TG	YYY	RTS
3	Z	CD	THH	QQQ	HHD

TABLE 2 WITH ONLY 1 MATCHING ID 

TABLE 2 ID	DESCRIPTION	VALIDITY	TENURE
1	THIS IS ON SALE	YES	12 MONTHS
23232	THIS IS OUT OF STOCK	NO	2 MONTHS
112341	DISCOUNTED	YES	3 MONTHS

RESULTING TABLE THAT IS NEEDED

TABLE 1 ID	DESCRIPTION	VALIDITY	TENURE
1	THIS IS ON SALE	YES	12 MONTHS
2	NULL	NULL	NULL
3	NULL	NULL	NULL

I know the above is easily availbale with Merge and then do a LEFT JOIN in it in Power Query, but my Table 2 is a DAX Generated Table which does not show up on the Power Query side for me to MERGE with Table 1. 

Thank You

[MFelix]

Hi @nirvana_moksh,

Create a relationship between both tables then add the TABLE1 ID to your table visual and the Other columns from table 2.

then filter out all blanks from TABLE1 ID

Regards,

MFelix

[nirvana_moksh]

So when I do that then the resulting Table only shows values that are also present in Table 2 based on the ID, I have the relationship set already. I just want all ID's from Table 1 and corresponding values from Table 2 and nulls for where there is no value present in Table 2. I did play with EVALUATE and GENERATEALL but that did not get me where I wanted this to be.