Create View from existing table

[Anonymous]

Hi,

I´m new to Power Bi and i need some help, so I hope you can help me. 
I have a table which looks like that:

Juni Juli Aug Sept Okt Nov Dez

x	x	x	x	x	x	x
x	1	1	1	1	0	0
1	0,5	1	1	0,5	1	1

And I want to create a view where i have to amount of 0,1,x and 0,5 summarized for each month

	x	1	0,5	0
Juni	2	20	3	1
Juli	2	20	3	1
Aug	2	20	3	1
Sept	2	20	3	1
Okt	2	20	3	1
Nov	2	20	3	1
Dezember	2	20	3	3

How can I achieve that? 
Thank you and best regards,

Christian

[Greg_Deckler · Accepted solution]

@Anonymous - So if that is your source table, generally you would want to unpivot those columns in Power Query. Then things should be pretty easy.

[v-yingjl · Accepted solution]

Hi @Anonymous ,

1. Select all of your column and use Unpivot columns in power query editor, close and apply it.

2. Put the new fields in a matrix visual, set the value field as count of values to get the expected result:

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you, I´m gonna try it! 🙂

[Greg_Deckler · Accepted solution]

@Anonymous - So if that is your source table, generally you would want to unpivot those columns in Power Query. Then things should be pretty easy.