topic Re: IF statement to return if currentdate is between 2 dates from fields to get true/false in DAX Commands and Tips

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

8047444 — Thu, 02 Mar 2023 21:39:01 GMT

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).

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

Greg_Deckler — Thu, 02 Mar 2023 23:04:19 GMT

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

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

8047444 — Fri, 03 Mar 2023 15:53:12 GMT

Greg_Deckler - thank you that works!