Forum Discussion
Create View from existing table
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
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.
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
3 Replies
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.
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 LiIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.