Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Create Column based on Date with item status

Hi 

 

I have an SLA column within my data, is it possible to create a column based on the SLA date which has the following: 

 

If SLA date has past then new column cell = Past SLA

If SLA date is equal to today or 30 days time then new column cell = Due Within 30 Days

if SLA date is greate than 30 days then new column cell = Within SLA

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi Anonymous,

    You can try to use the following calculated column formula to trace the date different different between 'SLA date' and 'system date' to get SLA status:

    SLA Status =
VAR diff =
    DATEDIFF ( TODAY (), Table[SLA Date], DAY )
RETURN
    IF (
        diff >= 30,
        "Within SLA",
        IF ( diff >= 0 && diff < 30, "Due Within 30 Days", "Past SLA" )
    )

    Regards,

    Xiaoxin Sheng

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi Anonymous,

    You can try to use the following calculated column formula to trace the date different different between 'SLA date' and 'system date' to get SLA status:

    SLA Status =
VAR diff =
    DATEDIFF ( TODAY (), Table[SLA Date], DAY )
RETURN
    IF (
        diff >= 30,
        "Within SLA",
        IF ( diff >= 0 && diff < 30, "Due Within 30 Days", "Past SLA" )
    )

    Regards,

    Xiaoxin Sheng