Forum Discussion
How many calls at the same time?
Hi virus190 ,
This is caused by calculation logic. Unavoidable. ☹️ Maybe others
In addition, I modify the expression a bit and it will be slightly better.
Column 2 =
VAR _1 = [Accepted]
VAR _2 = [Hang up]
RETURN
IF (
NOT (
ISEMPTY (
FILTER (
'Table',
'Table'[CALL ID] < EARLIER ( 'Table'[CALL ID] )
&& _2 >= [Accepted]
&& _1 <= [Hang up]
)
)
),
"x"
)
Or you can try to create a measure:
Measure =
VAR _1 =
MAX ( [Accepted] )
VAR _2 =
MAX ( [Hang up] )
RETURN
IF (
NOT (
ISEMPTY (
FILTER (
ALLSELECTED ( 'Table' ),
'Table'[CALL ID] < MAX ( 'Table'[CALL ID] )
&& _2 >= [Accepted]
&& _1 <= [Hang up]
)
)
),
"x"
)
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oh, i accidently hit the Accept solution button..
Well, for me it didnt work. The first one again, was loading forever. The second gave me everywhere an X.
Maybe it is easier just to get the number of same calls, i dont necessarily need the X, it would be just a way to count them. Is this possible?
- Icey5 years ago
Community Support
Hi virus190 ,
Oh, i accidently hit the Accept solution button..
Try this to cancel the operation.
Maybe it is easier just to get the number of same calls, i dont necessarily need the X, it would be just a way to count them. Is this possible?
Let me try it.
Best Regards,
Icey
- virus1905 years ago
Helper II
Hi Icey ,
thanks, changed it.
Im now trying to add an Index in PowerQuery and then add the Hang Up Timestamp from the Call before. So i can check if the Call before was still on the Call.
Like this:
= Table.AddColumn(#"Added index", "custom column", each #"Added index"{[Index]-1}[My Column])Im waiting for the result.