topic Re: Help with comparing two dates DAX in DAX Commands and Tips

Help with comparing two dates DAX

adoalan — Wed, 15 Feb 2023 12:10:49 GMT

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

Re: Help with comparing two dates DAX

FreemanZ — Wed, 15 Feb 2023 12:26:34 GMT

hi adoalan

Do you want to add a calculated column?

Are you really adding a calculated column

Re: Help with comparing two dates DAX

adoalan — Wed, 15 Feb 2023 12:35:31 GMT

Hey FreemanZ

Whatever works, colm or measure.

Cheers

Re: Help with comparing two dates DAX

FreemanZ — Wed, 15 Feb 2023 13:43:18 GMT

hi adoalan

try to use your code to create a calculated column.

Re: Help with comparing two dates DAX

tamerj1 — Wed, 15 Feb 2023 13:50:05 GMT

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

Re: Help with comparing two dates DAX

adoalan — Wed, 15 Feb 2023 14:48:10 GMT

Hi tamerj1 relationship in place.

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

Re: Help with comparing two dates DAX

adoalan — Wed, 15 Feb 2023 14:48:53 GMT

I tried but doesn t works

Re: Help with comparing two dates DAX

tamerj1 — Wed, 15 Feb 2023 15:13:52 GMT

adoalan

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

Re: Help with comparing two dates DAX

adoalan — Wed, 15 Feb 2023 15:44:49 GMT

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

Re: Help with comparing two dates DAX

tamerj1 — Wed, 15 Feb 2023 16:03:26 GMT

adoalan

Please create a calculated column in the gift table

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

"New",

"Existing"

)