Hi folks, I'm new to PowerBI and guess that my question can be answered rather easily by the experts here. I apologize upfront if this has been answered elsewhere - I just don't know the correct keywords to look for what I need 🤐 Here's my challenge.I have a table that looks more or less like this (I picked random numbers only for clarification). PeopleInformation 1Information 2Information 3...Adam167 Angela622 Michael472 Joe336 Lena617 ... I create different measures for each Information column. e.g. Avg, Min, Max, Standard deviation etc. What I'd like to have in the end is a table that is somehow "shifted" and only holds these calulated measures per Information, looking like this (more or less): InformationAvgMinMaxSD...Information 14,00162,121 Information 23,80172,588 Information 34,80272,588 ... Doing this in Excel would be easy for me, but in PowerBI.... well... I'm looking forward to your replies 🙂

If you unpivot your data, it will make your analysis and visualization much easier. In the query editor, select your first column, right click the header and choose "Unpivot Other Columns". This will give you three columns instead of four (People, Attribute, and Value - you can rename as needed). You can then write fewer measures (e.g., avg, min, max of your value column), and then use the attribute column as the legend in visuals and/or columns in a matrix. Pat

NielsFro

New Member

4 years ago

Solved

Create a new table with measures and a different layout

Hi folks,

I'm new to PowerBI and guess that my question can be answered rather easily by the experts here. I apologize upfront if this has been answered elsewhere - I just don't know the correct keywords to look for what I need 🤐

Here's my challenge.

I have a table that looks more or less like this (I picked random numbers only for clarification).

People	Information 1	Information 2	Information 3	...
Adam	1	6	7
Angela	6	2	2
Michael	4	7	2
Joe	3	3	6
Lena	6	1	7
...

I create different measures for each Information column. e.g. Avg, Min, Max, Standard deviation etc.

What I'd like to have in the end is a table that is somehow "shifted" and only holds these calulated measures per Information, looking like this (more or less):

Information	Avg	Min	Max	SD	...
Information 1	4,00	1	6	2,121
Information 2	3,80	1	7	2,588
Information 3	4,80	2	7	2,588
...

Doing this in Excel would be easy for me, but in PowerBI.... well... I'm looking forward to your replies 🙂

Need Help

mahoneypat
4 years ago
If you unpivot your data, it will make your analysis and visualization much easier. In the query editor, select your first column, right click the header and choose "Unpivot Other Columns". This will give you three columns instead of four (People, Attribute, and Value - you can rename as needed). You can then write fewer measures (e.g., avg, min, max of your value column), and then use the attribute column as the legend in visuals and/or columns in a matrix.

Pat

Forum Discussion

Create a new table with measures and a different layout

3 Replies

Related content

Need help creating a measure

Help to create DAX Measure

Cumulative Difference from Another measure

Reference different tables when creating a measure

Create a dynamic tree chart based on different measures