Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
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 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
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |