Hi Team,
Please help me with the below table for Pivot.
I have data like this.
| Employee | Year | Values |
| A | 2020 | 1.5 |
| B | 2020 | 1.6 |
| C | 2020 | 5.5 |
| D | 2020 | 6.7 |
| E | 2020 | 3.9 |
| F | 2020 | 9.7 |
| G | 2020 | 1.8 |
| A | 2021 | 6.6 |
| B | 2021 | 7.153571 |
| C | 2021 | 7.707143 |
| D | 2021 | 8.260714 |
| E | 2021 | 8.814286 |
| F | 2021 | 9.367857 |
| G | 2021 | 9.921429 |
| A | 2022 | 10.475 |
| B | 2022 | 11.02857 |
| C | 2022 | 11.58214 |
| D | 2022 | 12.13571 |
| E | 2022 | 12.68929 |
| F | 2022 | 13.24286 |
| G | 2022 | 13.79643 |
| A | 2023 | 14.35 |
| B | 2023 | 14.90357 |
| C | 2023 | 15.45714 |
| D | 2023 | 16.01071 |
| E | 2023 | 16.56429 |
| F | 2023 | 17.11786 |
| G | 2023 | 17.67143 |
| A | 2024 | 18.225 |
| B | 2024 | 18.77857 |
| C | 2024 | 19.33214 |
| D | 2024 | 19.88571 |
| E | 2024 | 20.43929 |
| F | 2024 | 20.99286 |
| G | 2024 | 21.54643 |
| A | 2025 | 22.1 |
| B | 2025 | 22.65357 |
| C | 2025 | 23.20714 |
| D | 2025 | 23.76071 |
| E | 2025 | 24.31429 |
| F | 2025 | 24.86786 |
| G | 2025 | 25.42143 |
| A | 2026 | 25.975 |
| B | 2026 | 26.52857 |
| C | 2026 | 27.08214 |
| D | 2026 | 27.63571 |
| E | 2026 | 28.18929 |
| F | 2026 | 28.74286 |
| G | 2026 | 29.29643 |
But need output below like this
| Row Labels | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 |
| A | 1.5 | 6.6 | 10.475 | 14.35 | 18.225 | 22.1 | 25.975 |
| B | 1.6 | 7.153571 | 11.02857 | 14.90357 | 18.77857 | 22.65357 | 26.52857 |
| C | 5.5 | 7.707143 | 11.58214 | 15.45714 | 19.33214 | 23.20714 | 27.08214 |
| D | 6.7 | 8.260714 | 12.13571 | 16.01071 | 19.88571 | 23.76071 | 27.63571 |
| E | 3.9 | 8.814286 | 12.68929 | 16.56429 | 20.43929 | 24.31429 | 28.18929 |
| F | 9.7 | 9.367857 | 13.24286 | 17.11786 | 20.99286 | 24.86786 | 28.74286 |
| G | 1.8 | 9.921429 | 13.79643 | 17.67143 | 21.54643 | 25.42143 | 29.29643 |
Note 1 output should be in DAX formula
2 Year column has up to 2090
Please help me with this
Thanks in advance,
