Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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,
@Anonymous
Do you want on DAX formula that will produce this output?
Can you not use a matrix table?
Create a matrix table:
In rows section drag Employee field, in columns section drag Year and in values drag the field Values
Image below:
Thanks for the replay @themistoklis but I am expecting the result should be a table visual
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |