If Statement with Dates

[garimajain85]

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

[DLynn91]

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 🙂

[ManuelBolz · Accepted solution]

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")

[AlienSx]