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!
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.
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!
Solved! Go to Solution.
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.
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!
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.
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.
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:
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!
It did, thank you!
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 |
---|---|
117 | |
105 | |
69 | |
67 | |
43 |
User | Count |
---|---|
148 | |
103 | |
103 | |
88 | |
66 |