How to show "Not Compliant" for a date that is before a date in a column

[GON76]

I want to display the text "Not Compliant" in the column of  table if the date is before 3 years.  I've been using the following, but I know I'm missing something in the parameter:

Learning Path Compliance = IF(([EXITDATE] > The Date),"Not Compliant","Compliant")

I'm not sure what I should replace "The Date" with or which formula I should be using.

Thanks!

[GON76 · Accepted solution]

Hi Royel, thanks for your response.  I tried using your statement using my column [EXITDATE], and I'm getting an error that says "The first argument to 'DATEADD' must specify a column." Do I need to reference the column again?

Compliance Status =

IF(

    [EXITDATE] < DATEADD(TODAY(), -3, YEAR),

    "Not Compliant",

    "Compliant"

)

[GON76 · Accepted solution]

Hi Royel, I used EDATE rather than DATEADD, and removed "YEAR" and I got it to work. Thanks for pointing me in the right direction!

[v-pgoloju · Accepted solution]

Hi @GON76,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Royel  and @danextian  for prompt and helpful responses.

Glad to hear it's working well for you! When you have a moment, could you please mark the relevant response as the accepted solution? This helps others in the community who might face a similar issue to find the answer more easily.

Thanks & Regards,

Prasanna Kumar

[danextian]

Hi @GON76 

How do you define "date is before 3 years"? What is the date reference date - today, selected date in the slicer?

[GON76]

Hi Dane, thanks so much for responding. I'm trying to put this column in a pivot table so I'm not using a slicer.  The reference date would be today's date.

[Royel]

Hi, @GON76 Thanks for your question. 

You want to show "Not Compliant" for dates before a certain threshold (3 years), try this Calculated Column Dax 

Compliance Status = 
IF(
    [YourDateColumn] < DATEADD(TODAY(), -3, YEAR),
    "Not Compliant",
    "Compliant"
)

 Find this helpful? ✔ Give a Kudo • Mark as Solution – help others too!

[GON76 · Accepted solution]

Hi Royel, thanks for your response.  I tried using your statement using my column [EXITDATE], and I'm getting an error that says "The first argument to 'DATEADD' must specify a column." Do I need to reference the column again?

Compliance Status =

IF(

    [EXITDATE] < DATEADD(TODAY(), -3, YEAR),

    "Not Compliant",

    "Compliant"

)

[GON76 · Accepted solution]

Hi Royel, I used EDATE rather than DATEADD, and removed "YEAR" and I got it to work. Thanks for pointing me in the right direction!

[Royel · Accepted solution]

@GON76  Great, I am so glad you solved it.

[v-pgoloju · Accepted solution]

Hi @GON76,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to @Royel  and @danextian  for prompt and helpful responses.

Glad to hear it's working well for you! When you have a moment, could you please mark the relevant response as the accepted solution? This helps others in the community who might face a similar issue to find the answer more easily.

Thanks & Regards,

Prasanna Kumar