Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |