Forum Discussion
Expression.Error:We cannot apply operator + to types Date and Number
Hi I keep the above error even after changing data type to Date.Trying to create a new custom column based on another column. This was the excel formula =IF(AND(AM2="M",OR(AL2="",AL2<TOD...
Table.AddColumn(CBCEventcalc, "PCF Event calc", each if [PCF Event] = "M" and ([Estimated Pickup] = null or [Estimated Pickup] <= Date.From(DateTime.LocalNow()))then
"PCF"
else
"")
It's still showing the error as shown below
It's still showing the error as shown below