Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

calculate age difference between dates from two different tables

Hi There,

 

I've been trying find the ageing of Opportunities based on the create and close date of them, however, in order to get the desired result I need to take the values from two different tables which are already linked (has a relation). Here's the DAX column I've tried:

 

Opp_Age = IF(
ISERROR(DATEDIFF('Opportunity History'[CreatedDate], RELATED(Opportunity[CloseDate]),MONTH)),
DATEDIFF(RELATED(Opportunity[CloseDate]),'Opportunity History'[CreatedDate], MONTH))
 
I'm getting a balnk column as a result.
 
Ant help on this would be appriciated!!! Thanks in advance.
Need Help

3 Replies

  • az38's avatar
    az38
    Community Champion
    6 years ago

    Hi Anonymous 

    Why dont you use just 

    Opp_Age = 
DATEDIFF('Opportunity History'[CreatedDate]; RELATED(Opportunity[CloseDate]);MONTH)

    What kind of error you get?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      az38 Thank you for your prompt response. This formula isn't working as the close date is not being taken by the DAX.

      • az38's avatar
        az38
        Community Champion
        6 years ago

        Anonymous why? what error you see?

        for what table you add the column? i added it for Opportunity History? what kind of relations between the tables do you use?