Hi Power BI Team,
I need help with the below query:
I have 2 tables - Accounts Table and Daily Balances table.
Accounts table holds the Customer No and the related Account no’s in them.
The Daily Balances table records the balance for each Account on a daily basis.
I have attached the sample dataset for your reference.
I need to find out the Customers who have funded thier Accounts in the first 10 days.
I came up with this , but I get 3 , whereas I should be getting 2, as only 101 and 103 funded thier accounts.
CALCULATE(COUNT(‘Accounts’[Customer No]),FILTER(‘Daily Balances’,‘Daily Balances’[Effective Date] >=TODAY()-11 && ‘Daily Balances’[Effective Date] <=TODAY()-1 ),‘Accounts’[Status]=“Active”)
Any help on this would be appreciated!