Help: Formula for Date in with condition

[EmadK]

I am using a condition to format a ROW.

ISNOTBLANK(
SELECT(Data Log[UniqueID], [Student ID]=[_THISROW].[Student ID])
)

The condition is applied to make a row look different:

• When the UniqueID ( inside Data Log table) exists in reference to the Student ID (in Data table) 
• AND the record date is today

I have created the first condition, but I am not sure how to add the second to the formula. 

Help please 🙂

[WillowMobileSys · Accepted solution]

You would need to use the AND() expression to join conditions.  Something like this:

ISNOTBLANK(
    SELECT(Data Log[UniqueID], 
       AND(
           [Student ID]=[_THISROW].[Student ID],
           [Date] = TODAY()
       )
    )
)

[EmadK]

This worked like a charm! Thank you so much. 🙏