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

 

 

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

    Thank you for taking the time out!

     

    Appreciate all the help 🙂 DataInsights 

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

    Thanks, this was a very useful measure.