Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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:
Hi @Anonymous
Why dont you use just
Opp_Age = DATEDIFF('Opportunity History'[CreatedDate]; RELATED(Opportunity[CloseDate]);MONTH)
What kind of error you get?
@az38 Thank you for your prompt response. This formula isn't working as the close date is not being taken by the DAX.
@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?
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |