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.
Dear all,
I have a table like below:
Name | Sesison Date | Question | Score |
People 1 | 7/1/2018 | Q1 | 2 |
People 1 | 7/1/2018 | Q2 | 3 |
People 1 | 7/1/2018 | Q3 | 1 |
People 1 | 7/1/2018 | Q4 | 2 |
People 1 | 8/1/2018 | Q1 | 2 |
People 1 | 8/1/2018 | Q2 | 1 |
People 1 | 8/1/2018 | Q3 | 3 |
People 1 | 8/1/2018 | Q4 | 1 |
People 1 | 8/20/2019 | Q1 | 2 |
People 1 | 8/20/2019 | Q2 | 4 |
People 1 | 8/20/2019 | Q3 | 2 |
People 1 | 8/20/2019 | Q4 | 1 |
People 2 | |||
People 2 | |||
People 2 | |||
People 2 | |||
People 2 | |||
People 2 | |||
People 2 |
Ex. When I filter people 1, I want to show the last session date score and the comparison with the previous score.
In this case, the last session date is 2019-08-20, so my ideal result is :
The first column is the last session score, then follow by a emoji to indicate it's improve/no change/worsen, and follow by a sentence to indicate the performance.
If the question score is higher then previous session, then it worsen, if lower, then improved.
Thank you so much. Below is the pdix file. If you can help me any part of the calculation, that would be appreciate it. Thanks!
https://1drv.ms/u/s!ArC4uvMBwvXvgQQbeh6EEtv3ZVSP?e=Zb7Oz1
https://1drv.ms/x/s!ArC4uvMBwvXvgQLM3Sy_GYY8WPpn?e=OH2WM8
Solved! Go to Solution.
Hi @xiumi_hou
There too many rows in your data, that takes much long time to run the measures, please kindly check the attached pbix whether meet your requirement.
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 |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |