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.
Hey,
I'm trying to calculate and filter duration colum,
My formula is:
CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,CTI[wait time]<"00:00:15"))
There is a problem with the last filter, I want to filter calls that their wait time duration is shorter than 15 sec, can you figure out what is the problem with the formula above?
Thanks
Solved! Go to Solution.
solution:
CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,SECOND(CTI[wait time])+MINUTE(CTI[wait time])*60>15))
solution:
CALCULATE(COUNTA(CTI[end type]), FILTER(CTI,CTI[end type]="ABANDON"),FILTER(CTI,SECOND(CTI[wait time])+MINUTE(CTI[wait time])*60>15))
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |