Calculating Overdue Dates based on a Column Value

[MW_TSC]

Hi!

I am trying to create a dashboard for different visuals around customer payments - this visual is specifically for whether or not a payment is overdue, however there are different variables based on domestic and commercial customers.

Commercial customers have 30 days after the invoice date before payment is due

Domestic customers have 14 days after the invoice date before payment is due

I have got to this stage in my formula creation where no syntax erros have been detected, however the column is still returning "Error" down all lines.

Please can anyone help? Screenshot below:

[MW_TSC]

That's great, thankyou!

[m_dekorte · Accepted solution]

Hi @MW_TSC,

You can't add numbers and dates, these are two different types of values

Use the Date.AddDays function instead.

To illustrate:
Date.AddDays( [Invoice Date], 30)