IF statement

[WJ876400]

Hi

I have the below dates in a table, what i want to do is create the Review check column. If the Scheduled review is 30 days or less than the actual review I want to return Not Scheduled. If it is over 30 days after the actual review I want to return the scheduled review date.

Actual Review	Scheduled Review	Review Check
01/09/2019	15/09/2019	Not Scheduled
01/09/2019	30/10/2019	30/10/2019
01/09/2019	05/09/2019	Not Scheduled
01/09/2019	01/11/2019	01/11/2019

thanks

[AlB]

Hi @WJ876400 

Review Check =
IF (
    Table1[scheduled review] - Table1[actual review] <= 30,
    "Not scheduled",
    FORMAT ( Table1[scheduled review], "DD/MM/YYYY" )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[WJ876400]

Sorry @AlB  I missed that the table looks like this as there is not always a date in the scheculed column

Actual Review	Scheduled Review	Review Check
01/09/2019	15/09/2019	Not Scheduled
01/09/2019	30/10/2019	30/10/2019
01/09/2019	05/09/2019	Not Scheduled
01/09/2019	01/11/2019	01/11/2019
01/09/2019	To be scheduled	Not Scheduled
01/09/2019	To be scheduled	Not Scheduled

[AlB · Accepted solution]

So that means that the scheduled review column is of type text and not date. Is it the same for the actual review columns? IF so,

Review Check =
IF (
    Table1[scheduled review] = "To be scheduled",
    "Not scheduled",
    IF (
        DATEVALUE ( Table1[scheduled review] ) - DATEVALUE ( Table1[actual review] ) <= 30,
        "Not scheduled",
        Table1[scheduled review]
    )
)

Please mark the question solved when done and consider giving kudos if posts are helpful.

Cheers  

[WJ876400]

Hi @AlB 

Sorry I haven't given you the full information - Scheduled review is TEXT and the actual review is Date.

The scheduled review date is from another measure that outputs the date or To be scheduled

thanks

[WJ876400]

Hi @AlB 

thanks for the quick response. I get the below error so it looks like I need to format the dates?