Forum Discussion

garimajain85's avatar
garimajain85
Frequent Visitor
2 years ago
Solved

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

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

DLynn91's avatar
DLynn91
New Member
2 years ago

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 🙂