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
Get step-by-step solutions from verified subject matter experts
