topic lookup 2 table with today -1 search in DAX Commands and Tips

lookup 2 table with today -1 search

Anonymous — Wed, 30 Mar 2022 09:33:37 GMT

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.

Re: lookup 2 table with today -1 search

amitchandak — Wed, 30 Mar 2022 13:10:58 GMT

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])))

Re: lookup 2 table with today -1 search

Anonymous — Fri, 01 Apr 2022 08:05:38 GMT

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.

Re: lookup 2 table with today -1 search

v-easonf-msft — Tue, 05 Apr 2022 07:42:58 GMT

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