Forum Discussion

Roym's avatar
Roym
Helper IV
4 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Roym 

Of course you can, you can use my formula to try it out.

 

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.

  • Roym's avatar
    Roym
    Helper IV
    4 years ago

    Anonymous I just tried it with some additional data and I didn't get it fully working correctly (yet). Hopefully you can give me some additional guidance. In the below screenshot (same report as you shared) I have some reall data. For most of them it going correctly but the change from session1 to session2 is not working correcltly I think. The first row related to session2 has an effective test and open review. Therefore it should be marked as effective as it is the first row related to session2. 

     

    • Roym's avatar
      Roym
      Helper IV
      4 years ago

      Anonymous Is this something you can help me with? So far I was unable to get this working unfortunatly. Thanks!!