topic Re: Date "IF" in DAX Commands and Tips

Date "IF"

dofrancis3 — Sat, 18 May 2024 10:25:20 GMT

Hi Guys!

I need your help!

Could you help me with a DAX mesure wicth can help me to have the status colomn based on stard and end date.

Please the screen below:

Thank you for your help

Re: Date "IF"

Greg_Deckler — Sat, 18 May 2024 11:10:08 GMT

dofrancis3 Maybe:

Measure = VAR __Today = TODAY() VAR __Start = MAX( 'Table'[Started] ) VAR __End = MAX( 'Table'[end_date] ) VAR __Result = SWITCH( TRUE(), __Start > __Today, "Upcoming", __End < __Today, "Completed", "Ongoing" ) RETURN __Result Column = VAR __Today = TODAY() VAR __Start = [Started] VAR __End = [end_date] VAR __Result = SWITCH( TRUE(), __Start > __Today, "Upcoming", __End < __Today, "Completed", "Ongoing" ) RETURN __Result

Re: Date "IF"

dofrancis3 — Sat, 18 May 2024 11:56:06 GMT

Thank you so much Greg_Deckler