lookup 2 table with today -1 search

[Anonymous]

Hi All,

I have lookup problem in BI, please help for provide a tips / suggestion to me. 

I have 2 table: 

Table A daily updated.
Table B is the master table.

result inactive data. 

I need to look up the non-active data between Table A and Table B.
I have lookup at Table B, it was the return of the full data (active) and the inactive data shown (BLANK).

how to lookup the opposite data (inactive data) and control the date today-1.

Mant Thank.

[amitchandak]

@Anonymous , One way is new table

Assume column name is ID

except(all(TableB[ID]), allselected(TableA[ID]))

or create a measure like this and plot with Table B ID

countrows(except(all(TableB[ID]), allselected(TableA[ID])))

[Anonymous]

Thank you replay. 

i have try the both formaul and today -1, is will list out 

Table A and Table B both red date,  not the opposite data. 

[v-easonf-msft]

Hi, @Anonymous 

Not sure what you mean by 'control the date today-1' ?

Can you share you expected result in excel?

I shared a sample pbix here. Hope it could work for you.

Best Regards,
Community Support Team _ Eason