If date is today return text string from custom column
Newbie here with simple newbie question(s).
Have table with custom column...
Want to display, in a Card visual, the string in [Today's Objective] column that corresponds with today's date, if today's date = one of the date's listed in the [Date] column. Trying IF, LOOKUPVALUE, etc but stuck. Is this a job for FILTER? This definitely doesn't work...
Today's Class = IF(TODAY()<MIN('Member25'[Date]),"This course begins on...", IF(TODAY()>MAX('Member25'[Date]),"This course has ended.", LOOKUPVALUE('Member25'[Date],'Member25'[Today's Objective],[Today's Objective]) ) )
Do I need the custom column?
How to add MIN('Member25'[Date]) to the end of the first return string.