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 Fi...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    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.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

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.