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'm trying to display which attempt we're on in terms of booking people in for Initial calls. I've inputted a table below of what the expected resuls will be
Membership | Call Date | Call Type | Attempt |
0001 | 10/10/2021 | Initial | 1st Attempt |
0001 | 15/11/2021 | Initial | 2nd Attempt |
0001 | 20/12/2021 | Initial | 3rd Attempt |
0002 | 01/09/2021 | Initial | 1st Attempt |
0002 | 10/11/2021 | Review | |
0003 | 09/09/2021 | Initial | 1st Attempt |
0003 | 10/10/2021 | Initial | 2nd Attempt |
0003 | 12/12/2021 | Review | |
0004 | 15/08/2021 | Initial | 1st Attempt |
0005 | 26/08/2021 | Initial | 1st Attempt |
It's basically looking to see if there has been any initial calls after the 1st Attempt and then display which numbered attempt it is on
I'd like this to be a custom column in the table view so I'd be able to easily filter using a silcer etc
Does anyone know how I can do this?
Please let me know if you have any questions
Thanks,
Mike
Solved! Go to Solution.
@michael_knight , I do saw any first call in your result column
I think a new column like
Var _1 = Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])
return
if(_1 =1, "1st Call", (_1 -1) & " Attempt" )
@michael_knight , A new column like below will give you number
Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])
You can convert 1 ->1st, 2-> 2nd
Hi @amitchandak, thanks for the reply. I tested that measure and it looks like it only counts the number of times a call has been attempted to be booked in. I'm looking at going into more details, for example if the call is the 1st call then return 1st Attempt, if it's the 2nd call then display 2nd Attempt and so on
Does that make sense?
@michael_knight , I do saw any first call in your result column
I think a new column like
Var _1 = Countx(filter(table, [Membership] = earlier([Membership]) && [Call Type] <> "Call Type" && [Call Date] <= earlier([Call Date])), [Call Date])
return
if(_1 =1, "1st Call", (_1 -1) & " Attempt" )
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |