Forum Discussion

cubedweller's avatar
cubedweller
Regular Visitor
7 years ago
Solved

power query formula error: cannot apply operator <

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

A sample of the data where Completed Paste Due <3 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.

 

  • 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.

1 Reply

  • 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.