cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper V
Helper V

Getting % by month since launch for several measures in visual

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:

 
# First = CALCULATE(COUNT('Sheet2'[Stage]), 'Sheet2'[Stage] = "First")
# Second = CALCULATE(COUNT('Sheet2'[Stage]), 'Sheet2'[Stage] = "Second")
First2Second = DIVIDE([# Second] ,[# First])
Output for this they way I see it should be:
 
1month: (4/10) = 40%
2 month: NA
3 month: (3/10) = 30%

No problem getting the converison by month or total, however I would like to see how many are converted within 1 month, 2 months etc. 
This goes for second2third and so on as well. How many are converted after each month

 

Stage       Client        date                                   Days   Days         index

                                                                           since  difference   

First1Wednesday, January 1, 20200 1
Procpect2Thursday, January 2, 20200 2
First3Friday, January 3, 20200 3
First4Saturday, January 4, 20200 4
First5Sunday, January 5, 20200 5
First6Monday, January 6, 20200 6
First7Tuesday, January 7, 20200 7
Second1Wednesday, January 8, 2020778
Second4Thursday, January 9, 2020559
Second2Friday, January 10, 20208810
Third1Saturday, January 11, 202010311
Third2Sunday, January 12, 202010212
Fourth2Tuesday, January 14, 202012213
Fourth1Wednesday, January 15, 202014414
Win1Thursday, January 16, 202015115
Lost2Friday, January 17, 202015316
Second6Tuesday, February 4, 2020292917
First8Friday, February 7, 20200 18
First9Saturday, February 8, 20200 19
First10Sunday, February 9, 20200 20
Third6Sunday, March 1, 2020552621
First11Tuesday, March 10, 20200 22
Fourth6Monday, March 23, 2020772223
Lost6Wednesday, April 1, 202086924
Second8Tuesday, April 7, 2020606025
Second9Monday, April 20, 2020727226
Second10Saturday, May 2, 2020838327
Third8Wednesday, June 3, 20201175728
Fourth8Saturday, June 20, 20201341729
Third9Thursday, July 2, 20201457330
Win8Sunday, July 12, 20201562231

 

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!

2 REPLIES 2
Super User IV
Super User IV

@PBISea - I'm not clear on what you are after. If that is sample data you have provided, what is your expected outcome?


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @Greg_Deckler 

 

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!

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors