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 =
WHERE Table_B.item =x)
Can you please help me out?
Go to Solution.
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.
View solution in original post
That worked for me, thanks. I'm still curious how to catch this one in DAX, for future reference.
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!