Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I would like to create a measure to calculate the variance of second lastest date for each Name. I have tried
sample data:
Survey ID | Name | Date | Respond ID | Score |
123 | A | 5/9/2021 | 1 | 10 |
123 | A | 5/9/2021 | 2 | 8 |
123 | A | 5/9/2021 | 3 | 3 |
123 | A | 5/9/2021 | 4 | 0 |
234 | B | 8/9/2021 | 1 | 5 |
234 | B | 8/9/2021 | 2 | 5 |
234 | B | 8/9/2021 | 3 | 10 |
234 | B | 8/9/2021 | 4 | 0 |
345 | A | 7/9/2022 | 1 | 2 |
345 | A | 7/9/2022 | 2 | 6 |
345 | A | 7/9/2022 | 3 | 8 |
345 | A | 7/9/2022 | 4 | 3 |
456 | B | 10/9/2022 | 1 | 1 |
456 | B | 10/9/2022 | 2 | 10 |
456 | B | 10/9/2022 | 3 | 8 |
Solved! Go to Solution.
Hi @Hayoung
Please replace ALL('Table') with ALLEXCEPT ( 'Table', 'Table'[Name] )
Hi @Hayoung
Please replace ALL('Table') with ALLEXCEPT ( 'Table', 'Table'[Name] )
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |