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.
I would like to calculate the score difference between the lastest score and its closest past score of the same Name, and then show the difference by show the green up, red down and no change symbol. Also, I would like to test whether the change has a significant change in the difference by one-tail t test when comparing it, and show it as a filled circle and non-filled circle. Below is the small sample data.
Index | Name | ID | Question | Score | Date |
1 | A | 1 | Q1_A1 | 10 | 1/9/2022 |
2 | A | 2 | Q1_A2 | 8 | 3/9/2022 |
3 | C | 1 | Q1_A5 | 0 | 5/9/2022 |
4 | A | 3 | Q1_A4 | 2 | 11/9/2022 |
5 | B | 1 | Q1_A2 | 8 | 18/9/2022 |
6 | C | 2 | Q1_A3 | 5 | 19/9/2022 |
7 | A | 4 | Q1_A3 | 5 | 20/9/2022 |
8 | A | 5 | Q1_A2 | 8 | 21/9/2022 |
9 | B | 2 | Q1_Q1 | 10 | 22/9/2022 |
10 | C | 3 | Q1_A1 | 10 | 24/9/2022 |
Q & Ans no. | Score |
Q1_A1 | 10 |
Q1_A2 | 8 |
Q1_A3 | 5 |
Q1_A4 | 2 |
Q1_A5 | 0 |
Hi @Hayoung
Please include the difference with the expected results sample table.
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 |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |