Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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?
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
Hello Check this out
Hello @ernum You can use matrix visual for thisOr 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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.