Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.