Forum Discussion
Adjust session result based on previous session
I have a table in PBI that shows a long list of assessment results, both the test and review, and based on that I need to calculate the New_Result. As example I have the below table. For session 1 an...
Hi Roym
Unique session/id is necessary , because you mentioned , if test=” Effective” and review=” Open” , the value of new result will return the previous review . But when you have multiple identical values，how do you judge the previous review ? So the unique value becomes the criterion for judging the order of precedence.
Best Regard
Community Support Team _ Ailsa Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous There is an unique identifier available like I now have in the below table. Would it be possible this way?
| Session | ID | Test | Review | New_Result |
| Session 1 | 20 | Effective | Effective | Effective |
| Session 1 | 21 | Effective | Open | Effective |
| Session 1 | 22 | Effective | Ineffective | Ineffective (Review is prefered to calculate the new result) |
| Session 1 | 23 | Effective | Open | Ineffective |
| Session 2 | 41 | Effective | Effective | Effective |
| Session 2 | 42 | Effective | Open | Effective |
| Session 2 | 43 | Effective | Ineffective | Ineffective (Review is prefered to calculate the new result) |
| Session 2 | 44 | Effective | Open | Ineffective |