Forum Discussion
Trying to create one table with multiple columns
I am new to Power Bi. I have survey results, where the questions are 1A, 1B, and I would like to create a table where the rows are Response "1", "2", "3" and the Columns are 1A, 1B. There should be three rows and not 8 combinations of 1 & 1, 1& 2, etc.
1A should have 25, 42, 35 and 1 B should have 14, 49, 39.
This formula in power query works for one column: = Table.Group(#"Removed Columns1", {"1A"}, {{"Count", each Table.RowCount(Table.Distinct(_)), Int64.Type}})
Once I add a second column, it creates additional combinations.
I hope I'm explaining well enough, I've been starring at this for a while.
Thanks!
Anonymous
you can try this
in PQ, select the first column and unpivot other columns
then you can use matrix visual to get the expected output
5 Replies
ryan_mayuSuper User
You can create a dim table which is 1, 2, 3 and connect this table to 1A and 1B.
what dose your sample data look like? could you pls provide some sample data?
- ryan_mayu
Anonymous
you can try this
in PQ, select the first column and unpivot other columns
then you can use matrix visual to get the expected output