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 all,
I have a current measure which works out the number of days since an enquiry was entered into the system and today
CRM_OpenEnq_DaysSinceEnqLead = calculate(SUMX(ENQUIRYDETAILS,Datediff(ENQUIRYDETAILS[EnquiryBecameLeadDate],Today(),Day)),ENQUIRYDETAILS[EnquiryCurrentStageID] IN {0,1,2})
This is working on a table however, I want to have a Card that has the number of times that the results are over 30 days.
Any help on this would be appreciated.
James
Solved! Go to Solution.
@JamesMF1982 , Try like
CRM_OpenEnq_DaysSinceEnqLead = calculate(Countrows(Filter(ENQUIRYDETAILS,Datediff(ENQUIRYDETAILS[EnquiryBecameLeadDate],Today(),Day)>30)),ENQUIRYDETAILS[EnquiryCurrentStageID] IN {0,1,2})
Hi, @JamesMF1982
Can you provide sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures. I look forward to your response.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please try this expression. I switched to using INT instead of DATEDIFF as it is more performant (especially since an IF would have been needed). The INT returns 1 or 0 for the T/F inside, so only the ones with >30 are counted.
Rows Over 30 =
CALCULATE (
SUMX (
ENQUIRYDETAILS,
INT ( ( TODAY () - ENQUIRYDETAILS[EnquiryBecameLeadDate] ) > 30 )
),
ENQUIRYDETAILS[EnquiryCurrentStageID] IN { 0, 1, 2 }
)
Pat
@JamesMF1982 , Try like
CRM_OpenEnq_DaysSinceEnqLead = calculate(Countrows(Filter(ENQUIRYDETAILS,Datediff(ENQUIRYDETAILS[EnquiryBecameLeadDate],Today(),Day)>30)),ENQUIRYDETAILS[EnquiryCurrentStageID] IN {0,1,2})
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
51 | |
46 | |
39 | |
19 | |
19 |