Splitting column items into new columns

[ernum]

Hello all,

I have a list like in below (example) and I need to split "Year" column into new columns.

It means, I need to show yearly score of each city in the columns (like 2019-2020-2021-2022-2023)..

But I can't do this with PowerQuery in any way, how can I do it with feature "Add Measure" or "Add New Column" with DAX?

Thank you,

[Cbutler]

Do you mean you need to Pivot the table?  Not sure if I am understanding the query correctly? If I am.... Select the year column, then pivot by value 
 

[BIswajit_Das]

Hello Check this out

[BIswajit_Das]

Hello @ernum  You can use matrix visual for this
Or you have create different calculated columns as per your requirements.

[ernum]

Hello, thanks for reply.

Actually when I put years to the column of the matrix table, I can get result almost that I wanted.

But when I try to add another information to the column, it's hiding it under the year columns