IF statement to return if currentdate is between 2 dates from fields to get true/false

[8047444]

Hello, I'm looking for some advice - My goal is to be able to show or hide a message on my dashboard for report users regarding data during payroll processing and hide when this message is not valid.

I'm trying to create a measure that will give me a 1(True) if Today() (currentdate) is between a start and end date.  Currently I have 2 fields - Payroll Processing Start and Payroll Processing End.  

Example:
Today (3/2/23)
(From my table which 1 row for each pay period and columns for pay dates, processing start, processing end..etc.)
Payroll_Processing_Start 2/26/2023      Payroll_Processing_End 3/1/2023
I would expect my measure to return 0 (False)

I tried an IF statement:

IF(Payroll_Calendar[PAYROLL_PROCESSING_START] <= TODAY() && Payroll_Calendar[CURRENTPAYROLLSTART] >= TODAY() 
but I'm getting an error too many rows to evaluate....
So I thought I could create a measure for the start and end dates but that's not working either (or I'm doing it wrong).

[8047444]

@Greg_Deckler - thank you that works!

[Greg_Deckler · Accepted solution]

@8047444 Try:

Measure =
  VAR __End = MAX(Payroll_Calendar[PAYROLL_PROCESSING_START])
  VAR __Start = MAX(Payroll_Calendar[CURRENTPAYROLLSTART])
  VAR __Today = TODAY()
  VAR __Result = IF( __Today >= __Start && __Today <= __End, 1, 0)
RETURN
  __Result