Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
Solved! Go to 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)
That's great, thankyou!
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)