power query formula error: cannot apply operator <

[cubedweller]

The power query formula shown below is given me the error shown below.

A sample of the data where Completed Paste Due ❤️ Days is displaying "error" is shown below as well.

Task Due Date and Task Finished Date are both of type date.

Any idea how to fix this error?

if [Completed Past Due]=1 and ([Task Finished Date]-[Task Due Date])>=0 and ([Task Finished Date]-[Task Due Date])<3 then 1 else 0

Power Query Error

Data

Thank you.

[Ashish_Mathur · Accepted solution]

Hi,

This should work

1. Change the data type of task finished date and task due date columns to Whole Numbers
2. Write your formula
3. Change the data type of task finished date and task due date columns to Date

Hope this helps.