Forum Discussion
Trying to recreate pivot table in Power Bi- Help
Hello,
I am trying to recreate a pivot table in power bi, but I'm having an issue. Below a sample of the data that I'm uploading to Power BI
| Shipment Ref | Week | Lane | Volume |
| H16202256 | 1 | A-B | 2 |
| 4711272736 | 1 | A-C | 3 |
| 4396010919 | 1 | A-B | 6 |
| 4395999189 | 1 | A-B | 3 |
| 4396067881 | 2 | A-B | 5 |
| H050189202 | 2 | A-B | 9 |
| 4395845866 | 2 | A-C | 3 |
| 617518651 | 3 | A-B | 2 |
| 617518512 | 3 | A-B | 5 |
| 3050115836 | 4 | A-B | 3 |
| H050195811 | 4 | A-C | 4 |
| 4711269949 | 4 | A-B | 9 |
And I want to create a new table that will organize the data like this:
| Week | Lane | Volume |
| 1 | A-B | 11 |
| 1 | A-C | 3 |
| 2 | A-B | 14 |
| 2 | A-C | 3 |
| 3 | A-B | 7 |
| 4 | A-B | 12 |
| 4 | A-C | 4 |
I'm new to Power BI and haven't been able to find a solution, so any help would be greatly appreciated!
Hi pwnagele,
You can create a table with this following formula ( I called my table data):
Table = SUMMARIZE(Data,Data[Week],Data[Lane], "Volume",SUM(Data[Volume]))
Then you can filter your week column in ascending....
Hope it helps....
Ninter
3 Replies
Hi pwnagele,
You can create a table with this following formula ( I called my table data):
Table = SUMMARIZE(Data,Data[Week],Data[Lane], "Volume",SUM(Data[Volume]))
Then you can filter your week column in ascending....
Hope it helps....
Ninter
Hi,
Select the Table visual. Drag Week and Lane to the Values section. Write this measure
=SUM(Data[Volume])
Hope this helps
