Forum Discussion

adoalan's avatar
adoalan
Helper III
3 years ago

Help with comparing two dates DAX

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'[...
dax formula
tamerj1's avatar
tamerj1
Community Champion
3 years ago

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

  • adoalan's avatar
    adoalan
    Helper III
    3 years ago

     

    Hi tamerj1 relationship in place.

     

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

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      adoalan 

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

      • adoalan's avatar
        adoalan
        Helper III
        3 years ago

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

    • tamerj1's avatar
      tamerj1
      Community Champion
      3 years ago

      adoalan 

      Please create a calculated column in the gift table

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