Roll Report Measure for invoices at month end
Hello everyone - I'm looking for assistance in helping me create a Roll Report measure for our Collections Team. Our company has N30 terms on our invoices, meaning the customer needs to pay off invoices within 30 days. So for example, if you look at Invoice #1: the invoice was generated on 4/27/2021 and is due on 5/27/2021. Today is 5/21/2021, 6 days BEFORE the invoice is due, so this is reflected in "Days Outstanding" column with a -6. If you look at Invoice #5, the invoice due date was 5/13/2021 and today is 5/21/2021 so the invoice is 8 days past due (shown in the Days Oustanding column), and so forth. My question is, I'm trying to create a measure which will show all invoices which will have a days outstanding of 1 or more on the LAST day of the month. So using this month as an example - I want to see all invoices that will be past due on May 31st. Using my chart above - Invoice 1,2,5,6 would show up in this measure because these (4) invoices would have a days outstanding of 1 or more on May 31st. Invoice 3 and 4 would NOT show up in this measure because on May 31st, these invoices will still NOT be past their due date. I've tried creating an End Of Month column and working measures based off that, but I keep hitting a dead end. Thanks in advance for your assistance!
