Forum Discussion
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) After today = Upcoming
Thanking you very much in advance.
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" )
