Forum Discussion

Roym's avatar
Roym
Icon for Helper IV rankHelper 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
Roym's avatar
Roym
Icon for Helper IV rankHelper 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
Icon for Helper IV rankHelper IV
4 years ago

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