Forum Discussion
Solved
Filter table based on value from another table
I have two tables ('Accounts' and 'Orders Created Last week' that have a relationship based on AccountID. I want to create a new table filtering the Accounts table by those with Orders Created La...
Perhaps:
'Accounts w/ Orders Last Week' = FILTER('Accounts', Accounts(AccountID) IN RELATEDTABLE('Orders'[AccountID]))
Otherwise, sample data and such would be very helpful.