Condition with current date (Today's date) greater than 6 months

[Anonymous]

Hi All,

I have a condition for date field to add +6 months to existing field. any suggestion to add it using calcuated column. 

Calculated column:

If Code= "Tenure" then Current Date > Created Date + 6 months

Please suggest for  6 months how to add for record created date field.

Regards,

VC

[Anonymous · Accepted solution]

HI @Anonymous,

I think you can use DATE function to calculate the corresponding date values.

Column1 =
VAR cDate =
    TODAY ()
RETURN
    IF (
        Table1[Code] = "Tenure",
        IF (
            Table1[Created Date]
                > DATE ( YEAR ( cDate ), MONTH ( cDate ) + 6, DAY ( cDate ) ),
            "Y",
            "N"
        )
    )

Regards,

Xiaoxin Sheng

[ryan_mayu]

@Anonymous 

pls try to use EDATE

If (Code= "Tenure" ,  edate(Created Date ,6))

EDATE function (DAX) - DAX | Microsoft Learn