Forum Discussion

ernum's avatar
ernum
Frequent Visitor
3 years ago

Splitting column items into new columns

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,

 

Need Help

4 Replies

  • Cbutler's avatar
    Cbutler
    Icon for Helper III rankHelper III
    3 years ago

    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's avatar
    BIswajit_Das
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

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

    • ernum's avatar
      ernum
      Frequent Visitor
      3 years ago

      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