Forum Discussion
Solved
IF statement to return if currentdate is between 2 dates from fields to get true/false
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).
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 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
2 Replies
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 __ResultGreg_Deckler - thank you that works!
