topic How to create measures for TASKS in DAX Commands and Tips

How to create measures for TASKS

Lyle — Tue, 31 Jan 2023 12:44:15 GMT

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.

Re: How to create measures for TASKS

johnt75 — Tue, 31 Jan 2023 14:01:49 GMT

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" )

Re: How to create measures for TASKS

Lyle — Tue, 07 Feb 2023 07:23:06 GMT

Thank you Jon, it got me started. Much appreciated