Forum Discussion
cubedweller
7 years agoRegular Visitor
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
- Change the data type of task finished date and task due date columns to Whole Numbers
- Write your formula
- Change the data type of task finished date and task due date columns to Date
Hope this helps.
1 Reply
- Ashish_MathurSuper User
Hi,
This should work
- Change the data type of task finished date and task due date columns to Whole Numbers
- Write your formula
- Change the data type of task finished date and task due date columns to Date
Hope this helps.