I need a way to calculate the difference between scores for Entry Assessments and Exit Assessments, per participant. What I want to see is if a participant's Exit score is higher than their Entry score. Some only have an Entry score, so I don't want to include those.
Solved! Go to Solution.
Consider this solution which converts Entry and Exit into separte score columns and then sums them
Edit the table in Power Query.
Click on the Stage column / Transform / Pivot column.
Then the create measure
Another solution is this ....
Click here to read more about the November 2022 updates!
This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.
Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.