Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ernum
Frequent Visitor

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?

 

ernum_0-1686309216575.png

 

Thank you,

 

4 REPLIES 4
Cbutler
Helper III
Helper III

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 
Pivot 1.PNGpivot 2.PNG 

 

BIswajit_Das
Resolver III
Resolver III

Hello Check this out

s1.PNG

s2.PNGs3.PNG

BIswajit_Das
Resolver III
Resolver III

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

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

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.