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

% of Growth with Alpha Value

Hi!

 

Working on something where I need a percent growth between different tests. What we want to see change on is an alpha value though, so not sure how to work out how we can show the change. 

 

growth.PNG

 

Here's an example. Right now we have 3 different tests that are labeled as windows. The 1st was an "I" then for the 2nd and 3rd they have a "J". So they moved up a level for the 2nd window but not the 3rd. Is there a way we can have this displayed, and also have a percentage of individuals who moved up a level?

 

Thanks!

2 ACCEPTED SOLUTIONS
Super User II
Super User II

Try this: 

First a calculated column to get an index, assuming you window column works as it seems:

Index = RIGHT(Test[Window];1)

Then i make another calculated column:

Upgrade = 
VAR index = Test[Index]
Return
IF(CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) = BLANK() ; "No Upgrade" ;
IF(
    CALCULATE(SELECTEDVALUE(Test[Ind. Level]);Test[Index]=index) <> CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) ; 
    "Upgrade"
    ; 
    "No Upgrade" 
))
This calculates based on index, assuming that you have more than one person participating in these tests you will need to implement that into the index so that it looks at each person/window individually.

Hope this helps! 🙂

image.png


Connect on LinkedIn

View solution in original post

That implies that there you are comparing text with number format! I think it's the new index column that is in text format and not number. Change it to number and see if it works! 


Connect on LinkedIn

View solution in original post

6 REPLIES 6
Super User II
Super User II

Try this: 

First a calculated column to get an index, assuming you window column works as it seems:

Index = RIGHT(Test[Window];1)

Then i make another calculated column:

Upgrade = 
VAR index = Test[Index]
Return
IF(CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) = BLANK() ; "No Upgrade" ;
IF(
    CALCULATE(SELECTEDVALUE(Test[Ind. Level]);Test[Index]=index) <> CALCULATE(SELECTEDVALUE(Test[Ind. Level]);ALL(Test);Test[Index]=index-1) ; 
    "Upgrade"
    ; 
    "No Upgrade" 
))
This calculates based on index, assuming that you have more than one person participating in these tests you will need to implement that into the index so that it looks at each person/window individually.

Hope this helps! 🙂

image.png


Connect on LinkedIn

View solution in original post

Hi!

 

From the screenshot you have on the bottom that upgrade column is what I'm looking for. I'm having trouble with creating the columns though, not sure if I need to follow yours exactly or edit it. 

 

growth 2.PNG

Hi @Lorraine 

Please replace ";" with ","

 

Best Regards

Maggie

Hi @v-juanli-msft 

 

I replaced it with a comma and was able to get that first column. 

 

For that second column that @tex628 created I was getting a similar error so I replaced the semicolons with commas again. Now I'm getting this error:

 

growth 3.PNG

 

That implies that there you are comparing text with number format! I think it's the new index column that is in text format and not number. Change it to number and see if it works! 


Connect on LinkedIn

View solution in original post

It did, thank you!

Helpful resources

Announcements
secondImage

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

secondImage

Power BI Women

Join our monthly meetings and learning sessions.

secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors