Pivot Table by using DAX

[Anonymous]

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,

[themistoklis]

@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:

[Anonymous]

Thanks for the replay @themistoklis  but I am expecting the result should be a table visual