Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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
Greg_Deckler
Super User
Super User

@Anonymous - 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!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.