Help with comparing two dates DAX

[adoalan]

Hi,

Can you help me with the below formula.

I want to compare the two dates but is asking to use an agregation

New Existing = IF(nfp_giftaiddeclaration[Created On] <= EDATE('contact'[Created On],1),

    "New",

    "Existing"

)

Many thanks

ADO

[tamerj1]

Hi @adoalan 
Is there a relationship between the two tables? Also please explain the logic behind this calculation.

[adoalan]

Hi @tamerj1 relationship in place.

The logic is if Created on from gift table <=with Created on from contact table then "New",
"Existing"

[tamerj1]

@adoalan 

Please create a calculated column in the gift table

New Existing = IF(nfp_giftaiddeclaration[Created On] <= RELATED('contact'[Created On]),

    "New",

    "Existing"

)

[tamerj1]

@adoalan 

Ok but is the logic behind using EDATE? Also in which table would ou like to create this column?

[adoalan]

the formula was used in the past by someone else. It doesn t matter in what table.

[FreemanZ]

hi @adoalan 

Do you want to add a calculated column?

Are you really adding a calculated column

[adoalan]

Hey @FreemanZ 

Whatever works, colm or measure.

Cheers

[FreemanZ]

hi @adoalan 

try to use your code to create a calculated column. 

[adoalan]

I tried but doesn t works