Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Hayoung
Helper IV
Helper IV

Calculate the difference of the same Name between two closest date and show it by up and down arrows

 

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.

 

IndexName IDQuestionScoreDate
1A1Q1_A1101/9/2022
2A2Q1_A283/9/2022
3C1Q1_A505/9/2022
4A3Q1_A4211/9/2022
5B1Q1_A2818/9/2022
6C2Q1_A3519/9/2022
7A4Q1_A3520/9/2022
8A5Q1_A2821/9/2022
9B2Q1_Q11022/9/2022
10C3Q1_A11024/9/2022
Q & Ans no.Score
Q1_A110
Q1_A28
Q1_A35
Q1_A42
Q1_A50
1 REPLY 1
tamerj1
Super User
Super User

Hi @Hayoung 
Please include the difference with the expected results sample table.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.