Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

check for relation with other table

I want to check if there is one (or more) row(s) in another table (table2), with a relation to the first table. I've found a soltion which I've tryed in my ow model but now I get the error: - The fu...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, Anonymous

     After my research, you can do these as below:

Assume that we have two table as below

table1

table2

and then we can use LOOKUPVALUE Function to check whether there are values in the column of table1 exist in the column of table2 like below:

 

Column = LOOKUPVALUE(FeitFactuurregel[xToewijzingnummer],FeitFactuurregel[xToewijzingnummer],FeitLeveringActueel[xToewijzingnr])

 

 

If it is not your case, please share some simple data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

 

 

Best Regards,

Lin

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

v-lili6-msft: Sorry for the delay, this is the situation, but now I get the error: 

The function LOOKUPVALUE is not available als part of de calculated column DAX-expression in DirectQuery models.