Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have used this youtube video as a starting point to create what I would like to achieve.
I have a sample table with stages each client was in or entered and then the following stages. They can drop out from any stage.
I have created some measures where I look at the percentage conversion from i.e first stage to second:
Stage Client date Days Days index
since difference
First | 1 | Wednesday, January 1, 2020 | 0 | 1 | |
Procpect | 2 | Thursday, January 2, 2020 | 0 | 2 | |
First | 3 | Friday, January 3, 2020 | 0 | 3 | |
First | 4 | Saturday, January 4, 2020 | 0 | 4 | |
First | 5 | Sunday, January 5, 2020 | 0 | 5 | |
First | 6 | Monday, January 6, 2020 | 0 | 6 | |
First | 7 | Tuesday, January 7, 2020 | 0 | 7 | |
Second | 1 | Wednesday, January 8, 2020 | 7 | 7 | 8 |
Second | 4 | Thursday, January 9, 2020 | 5 | 5 | 9 |
Second | 2 | Friday, January 10, 2020 | 8 | 8 | 10 |
Third | 1 | Saturday, January 11, 2020 | 10 | 3 | 11 |
Third | 2 | Sunday, January 12, 2020 | 10 | 2 | 12 |
Fourth | 2 | Tuesday, January 14, 2020 | 12 | 2 | 13 |
Fourth | 1 | Wednesday, January 15, 2020 | 14 | 4 | 14 |
Win | 1 | Thursday, January 16, 2020 | 15 | 1 | 15 |
Lost | 2 | Friday, January 17, 2020 | 15 | 3 | 16 |
Second | 6 | Tuesday, February 4, 2020 | 29 | 29 | 17 |
First | 8 | Friday, February 7, 2020 | 0 | 18 | |
First | 9 | Saturday, February 8, 2020 | 0 | 19 | |
First | 10 | Sunday, February 9, 2020 | 0 | 20 | |
Third | 6 | Sunday, March 1, 2020 | 55 | 26 | 21 |
First | 11 | Tuesday, March 10, 2020 | 0 | 22 | |
Fourth | 6 | Monday, March 23, 2020 | 77 | 22 | 23 |
Lost | 6 | Wednesday, April 1, 2020 | 86 | 9 | 24 |
Second | 8 | Tuesday, April 7, 2020 | 60 | 60 | 25 |
Second | 9 | Monday, April 20, 2020 | 72 | 72 | 26 |
Second | 10 | Saturday, May 2, 2020 | 83 | 83 | 27 |
Third | 8 | Wednesday, June 3, 2020 | 117 | 57 | 28 |
Fourth | 8 | Saturday, June 20, 2020 | 134 | 17 | 29 |
Third | 9 | Thursday, July 2, 2020 | 145 | 73 | 30 |
Win | 8 | Sunday, July 12, 2020 | 156 | 22 | 31 |
My hope is to get something like this as my output data:
Months since launch First2second conv Second2third conv
1 month 40% (4/10) 57.14% (4/7)
2 month NA NA
3 month 30% ( 3/10) NA
Attached my pbix test report here
Appreciate any help!
Thanks!
@Anonymous - I'm not clear on what you are after. If that is sample data you have provided, what is your expected outcome?
Sorry about that. I have updated my post now with example of what I would like as output.
Hope that will make it more clear. Thanks!
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |