check if an expire date is within 18 months from now

[Samiran]

Is this expression supposed to work? SO that the count of such "matches" can be aggregated in an insight to report on:

case(

    (addMonths(

        $currentDate,

        18

    ) > WPR_test.Lease.Expire_Date),

    1,

    0

)

[Samiran]

case(

    (addMonths(

        $currentDate,

        18

    ) > WPR_test.Lease.Expire_Date),

    1,

    0

)

[anurag]

Formula looks good.

I will recommend to add this as a formula column (flag with 0 or 1 value)) in physical table and then use aggregation on this flag to show in insight in dashboard.