Filter TableA on [a.date] = equal to [b.date] from TableB WHERE [b.item = x]?

[Peter_ROC]

Hi there, I'm pulling my hair out on this one, it seems obvious but I just can't find out how to do it....

Table_A contains an errorlog with a date column.

Table_B contains different items with lastrun_date = date column.

I want to filter Table_A on equal dates from (Table_B WHERE Table_B.item = x)

In T-SQL this would translate to:

SELECT * FROM Table_A
WHERE Table_A.date = 
 (SELECT Table_B.lastrun_date
WHERE Table_B.item =x)

Can you please help me out?

[v-jiascu-msft · Accepted solution]

Hi @Peter_ROC,

What's your data model like? If you can establish relationship between dates, the solution could be easy without a formula. You can check out the demo here.

Best Regards,

Dale

[Peter_ROC]

Hi Dale,

That worked for me, thanks. I'm still curious how to catch this one in DAX, for future reference.