Question: Add a new matrix table to your page called AR by Customer that shows the customer and invoices in rows, and earliest invoice due date,

Add a new matrix table to your page called AR by Customer that shows the customer and invoices in rows, and earliest invoice due date, age, and balance as values. Create a parameter showing the Report Date as 12/31/2020. Hint: Create a new column and use the DATE() function. Create a new measure showing the Age as the difference between the Invoice Due Date and the Report Date. Hint: Use the DATEDIFF() function to calculate the age and the MIN() function on the date fields to load specific dates. Use the AR Balance you created in Part 1 Filter the table to show only outstanding balances that are greater than 0. Clean up the formatting and titles of your visual. Don't forget to remove the November filter for this visual. You want to see the entire year to get an aging of all invoices

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!