Power BI - averages and calculations for forecasting

Hi,

Hope you are all keeping well, Wonder if you can help?

Im working with income and payment data to build a dashboard for my receivables function.

They would like to be able to see the likelihood of an invoice being paid within the current month, based on historical payment data and days left in the month.

My dashboard shows days left in the month, average days to pay for each customer (where they have had prior invoices), how many days old each invoice is and what the age of each invoice will be at month end. What i would like to show is if the invoice age is -

< than average days to pay - "NO"
> than average days to pay but by less than 31 - "YES"
if ages at month end is > 31 days above average the "CALL"

Client No. / Client Name / Outstanding / Due date / Average Days to pay / Days aged at month end.


Average days to pay is a format on the visual not a column in the dataset.

hope this makes sense?


Thanks

Helen