Can someone please help me with this?

This is a Many-To-Many Relationship Problem. Consider that bank customers can have multiple accounts, and accounts can have multiple customers. When an account has multiple customers, they're commonly called joint account holders. In the below dAccount table, there are two bank accounts. In the customer table, there are two customers, or account holders. Account #1 has two joint account holders. This is reflected in the dCustomer table. Account #2 has only one account holder. The fTransaction table shows the amounts that have been added and subtracted from the accounts. Your goal is to create the two reports: Total for Accounts and Total for Customer, as seen in the picture to the right. In this workbook, use Power Query, DAX Formulas and a Data Model Pivot Table to solve this problem. fTransactions dAccount d Customer | AccountID CustomerID Account Account 2 Amoun 125 1 Account 1 Checking 2 CD Customer 43 Sioux Radcliff 44 Miki Kim 1 2 1 2 Date AccountID 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 1 275 -25 500 200 2 1 Customer Miki Kim Sioux Radcliff Grand Total Total Amounts $1,075.00 $300.00 $1,075.00 Account CD Checking Grand Total Total Amounts $775.00 $300.00 $1,075.00 This is a Many-To-Many Relationship Problem. Consider that bank customers can have multiple accounts, and accounts can have multiple customers. When an account has multiple customers, they're commonly called joint account holders. In the below dAccount table, there are two bank accounts. In the customer table, there are two customers, or account holders. Account #1 has two joint account holders. This is reflected in the dCustomer table. Account #2 has only one account holder. The fTransaction table shows the amounts that have been added and subtracted from the accounts. Your goal is to create the two reports: Total for Accounts and Total for Customer, as seen in the picture to the right. In this workbook, use Power Query, DAX Formulas and a Data Model Pivot Table to solve this problem. fTransactions dAccount d Customer | AccountID CustomerID Account Account 2 Amoun 125 1 Account 1 Checking 2 CD Customer 43 Sioux Radcliff 44 Miki Kim 1 2 1 2 Date AccountID 01/01/2020 01/02/2020 01/03/2020 01/04/2020 01/05/2020 1 275 -25 500 200 2 1 Customer Miki Kim Sioux Radcliff Grand Total Total Amounts $1,075.00 $300.00 $1,075.00 Account CD Checking Grand Total Total Amounts $775.00 $300.00 $1,075.00