Notifications
Clear all
Power Query
3
Posts
3
Users
0
Reactions
118
Views
Topic starter
I could have sworn this worked last month when I first created, but i am getting an error on my Custom column.
Expression.Error: We cannot apply operator - to types Date and Number. I have 4 columns that to create a count if an item was late or not based on the received date minus 5, since we have a 5 day buffer.
Here is one of my custom column formulas: if [#"[RCT]Date Received (Date)"]-5 <= [#"[PO]Due Date (Date)"] then 0 else 1
i've attached my source file as well as the TEMPLATE file that houses the power query. Thanks in advance for your help!!
Kasey
Posted : 30/05/2019 9:19 am
Hi Kasey,
You need to use the Date.AddDays function to adjust the date e.g.
if Date.AddDays([#"[RCT]Date Received (Date)"],-5) <= [#"[PO]Due Date (Date)"] then 0 else 1 Mynda
Posted : 31/05/2019 6:06 am
Thank you, Mynda!! That was easy
Posted : 01/06/2019 8:37 am
