cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nirvana_moksh Established Member
Established Member

DAX Issues

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 IDCOLUMN1COLUMN2COLUMN3COLUMN4COLUMN5
1XABTTYYIYT
2YBCTGYYYRTS
3ZCDTHHQQQHHD

 

 

 

TABLE 2 WITH ONLY 1 MATCHING ID 

 

TABLE 2 IDDESCRIPTIONVALIDITYTENURE
1THIS IS ON SALEYES12 MONTHS
23232THIS IS OUT OF STOCKNO2 MONTHS
112341DISCOUNTEDYES

3 MONTHS

 

 

 

 

RESULTING TABLE THAT IS NEEDED

 

TABLE 1 IDDESCRIPTIONVALIDITYTENURE
1THIS IS ON SALEYES12 MONTHS
2NULLNULLNULL
3NULLNULLNULL

 

 

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

2 REPLIES 2
Super User
Super User

Re: DAX Issues

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


Regards

MFelix


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




nirvana_moksh Established Member
Established Member

Re: DAX Issues

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.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)