Hello, maybe someone from community could help me.
I'm need to use FILTER expression in an ER data model, I need to define two conditions for FILTER expression but I didn't found if it is possible
Tried with:
FILTER(LIST, CONDITION 1 AND CONDITION 2)
FILTER(LIST, AND(CONDITION1, CONDITION2))
Hi LuisGT,
Please follow the post on Microsoft Learn that is mentioned by Judy.
As example, You can use WHERE or FILTER as follow:
FILTER(LedgerJournalTable,
LedgerJournalTable.JournalNum='$notSentTransactions'.JournalNum)
'$notSentTransactions': Is cacluated feild for LedgerJournalTrans.
Hi LuisGT,
The summary of List of ER functions in the list category are presented. Currently the syntax of List does not support this operation.
André Arnaud de Cal...
292,111
Super User 2025 Season 1
Martin Dráb
230,934
Most Valuable Professional
nmaenpaa
101,156