Forum Discussion
If Statement with Dates
Trying to add a column with If then statement:
if [DOH]>= Date.IsInPreviousNDays([HR Data Received Date],180 )
then"Active"else"Inactive"
and reciving following error message:
Expression.Error: We cannot apply operator < to types Logical and Date.
Details:
Operator=<
Left=FALSE
Right=2/15/2021
Hello garimajain85,
the result from Date.IsInPreviousNDays([HR Data Received Date],180 ) is TRUE or FALSE.
Next you try to calculate if [DOH] >= TRUE/FALSE then [...]
I thing you want this
if [DOH] >= Date.AddDays([HR Data Received Date], 180)
then "Active"
else "Inactive")
3 Replies
Hello garimajain85,
the result from Date.IsInPreviousNDays([HR Data Received Date],180 ) is TRUE or FALSE.
Next you try to calculate if [DOH] >= TRUE/FALSE then [...]
I thing you want this
if [DOH] >= Date.AddDays([HR Data Received Date], 180)
then "Active"
else "Inactive")Hello,
I am wanting to make a custom column that tells me if a customer order date exceeds a certain # of days past production end. I.E If Column X >=7+ days of column y, return "contact ae" or if false "in window". Here is what i tried and no luck. Any ideas how to write this out in DAX?
Column = IF('Sort Report'[CDD].[Date]='Sort Report'[EPED].[Date]>7,"Contact AE","In Window")Any help is appreciated 🙂
