Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello everyone
I have a table like in the picture
I want to make this table as below?
I gave it as an example, but it continues until 2021-2022-2023.
thanks.
Solved! Go to Solution.
Hi @hakanbacak60. Remove the column attitude. Then select the Gender column and find Unpivot Other Columns in the ribbon. That should get you where you want to be. Hope this helps!
Hi @hakanbacak60. I'm reciting this from memory so it might not be perfect, but if you look a little bit, it might get you where you want to go. Select columns Gender and Year. Somewhere on the Ribbon is Transform > Group By. Look for that. Sum up the % column. The downside of doing that is that it's going to remove individual percentages and you're stuck with aggregations which might finder further analysis.
I would suggest creating a DAX measure for this. Could simply be SUM([%]) but hard to tell without knowing how you intend to use it.
Thank you. So how can I do the operation in the picture by adding a new column.
Hi @hakanbacak60. I'm reciting this from memory so it might not be perfect, but if you look a little bit, it might get you where you want to go. Select columns Gender and Year. Somewhere on the Ribbon is Transform > Group By. Look for that. Sum up the % column. The downside of doing that is that it's going to remove individual percentages and you're stuck with aggregations which might finder further analysis.
I would suggest creating a DAX measure for this. Could simply be SUM([%]) but hard to tell without knowing how you intend to use it.
Hi @hakanbacak60. Remove the column attitude. Then select the Gender column and find Unpivot Other Columns in the ribbon. That should get you where you want to be. Hope this helps!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |