Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Team,
I need to show the count of tickets that were opened before this month and are resolved or still open in the present month..
I have written a Measure but getting wrong count :
@FaisalImam , A measure like
backlog = CALCULATE(COUNT(Incident[NUMBER]),FILTER(Incident,eomonth(Incident[OPENED],0) <= eomonth(Today(),-1)
&& (isblank(Incident[RESOLVED]) || eomonth(Incident[RESOLVED],0) > eomonth(Today(),-1) )) )
Also, refer
Thank you somuch sir @amitchandak .
logic worked perfectly. Can you explain " eomonth(Incident[OPENED],0) <= eomonth(Today(),-1"
User | Count |
---|---|
101 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
98 | |
97 | |
73 | |
72 |