Forum Discussion

Lyle's avatar
Lyle
Frequent Visitor
3 years ago
Solved

How to create measures for TASKS

Hello Community,   I hope you are good and wondering if you can help me please.   I'd like to create a new column called STATUS which says:   1) Before today = Overdue 2) Today = Due Today 3)...
  • johnt75's avatar
    johnt75
    3 years ago

    You could create a column like

    Status =
VAR DaysDiff =
    DATEDIFF ( TODAY (), 'Table'[Scheduled date], DAY )
RETURN
    SWITCH (
        TRUE (),
        DaysDiff < 0, "Overdue",
        DaysDiff > 0, "Upcoming",
        "Due today"
    )
Lyle's avatar
Lyle
Frequent Visitor
3 years ago

Thank you Jon, it got me started. Much appreciated