calculate age difference between dates from two different tables

[Anonymous]

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.

[az38]

Hi @Anonymous 

Why dont you use just 

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

What kind of error you get?

[Anonymous]

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

[az38]

@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?