Forum Discussion

Josh1994's avatar
Josh1994
Icon for Helper II rankHelper II
4 years ago
Solved

Need help - Comparing two dates (or blank data)

Hi!   I am trying to make a new column based on two others. Essentially, it is checking that the "actual completed date" is less than or equal to the target date.   The bit im having an issue wi...
Need Help
  • DataInsights's avatar
    DataInsights
    4 years ago

    Josh1994,

     

    Try this calculated column:

     

    Compliance = 
VAR vToday =
    TODAY ()
VAR vResult =
    SWITCH (
        TRUE,
        NOT ISBLANK ( Table1[Actual Completed date] ), IF ( Table1[Actual Completed date] <= Table1[Target date], "Yes", "No" ),
        ISBLANK ( Table1[Actual Completed date] ) && Table1[Target date] > vToday, "Yes", "No"
    )
RETURN
    vResult

     

     

DataInsights's avatar
DataInsights
Icon for Super User rankSuper User
4 years ago

Josh1994,

 

Try this calculated column:

 

Compliance = 
VAR vToday =
    TODAY ()
VAR vResult =
    SWITCH (
        TRUE,
        NOT ISBLANK ( Table1[Actual Completed date] ), IF ( Table1[Actual Completed date] <= Table1[Target date], "Yes", "No" ),
        ISBLANK ( Table1[Actual Completed date] ) && Table1[Target date] > vToday, "Yes", "No"
    )
RETURN
    vResult

 

 

rohitpoojari's avatar
rohitpoojari
Icon for Helper I rankHelper I
2 years ago

Thanks, this was a very useful measure.