If next day from now time is a prodcutive day then flag 1 else 0

[Applicable88]

Hello,

I have a mastercalendar with all dates and a flag 1 or 0 , for each day if its a productive day or not.

Monday til friday the flag is 1, Saturday and Sunday its 0. 

That mastercalendar is connected to a factable column called NOWTIME where I simply pull the now UTC time as date :

NOWTIMEUTC].[Date]

I now want to make a additional calculated column to check if the next day is a productive day whenever I make Dataset refresh:

CheckIFNextDayISProductive=

IF( Related(Mastercalendar[Date]) = NEXTDAY(Facttable[NOWTIMEUTC].[Date])  && Related(Mastercalendar[ProduductiveDay]) = 1, 1, 0)

I always get 0, so there is something wrong with the syntax I guess.

Thank you very much in advance.

Best. 

[tamerj1 · Accepted solution]

Hi @Applicable88 

please try

CheckIFNextDayISProductive =
IF (
    RELATED ( Mastercalendar[Date] ) = Facttable[NOWTIMEUTC].[Date] + 1
        && RELATED ( Mastercalendar[ProduductiveDay] ) = 1,
    1,
    0
)

[YukiK]

I don't think that's how you're supposed to use nextday function. If you wanna compare a date and the next day, you can use the date function like in the following:

The next day = DATE(YEAR(YOURDATE), MONTH(YOURDATE), DAY(YOURDATE)+1)