Forum Discussion
Calculate the difference between two closest date, and significance difference
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....
Jihwan_Kim
Super User
Super UserHi,
I tried to create something like below.
When searching for UNICHAR symbols, I could not find what you want, but I hope you can find ones.
Please check the below picture and the attached pbix file.
I hope the below can provide some ideas on how to create a solution for your actual data model.
All measures are in the attached pbix file.
What I mean significance here is testing the statistically significance difference, which mean i have to use the one-tailed t-test