Forum Discussion
Creating a table with summarized values column with month/year as well?
Hi,
I want to create a table that has Quantity on Hand, Consumption Quantity.
I am aware that I can create a Matrix with the Month/Year as the columns.
The problem is that, I want to also include the summarized values like a table, without having it repeat.
Do I just have to make a calculated column for each Month and put that in the table?
Here is what I want:
| Item | Quantity on Hand Summarized | Consumption Quantity Jan - 2020 | Consumption Quantity Feb - 2020 | Consumption Quantity March - 2020 | Consumption Quantity April - 2020 | Consumption Quantity May - 2020 |
| ABC | 10 | 2 | 2 | 5 | 5 | 5 |
| DEF | 11 | 1 | 1 | 3 | 1 | 2 |
3 Replies
PBIUWO , What I am getting that you need a hybrid table table + matrix with Column
Workarounds
https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/963588#M428vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebcRight, thanks.
For the columns, I actually want it to be dyanmic, the last 12 months.
Do you think I can somehow use a positioning method for the column location to match them instead of finding the matching key?
Thank you,
PBIUWO
I am not quite sure but you should have date column to create a measure to get Consumption Quantity of last 12 months.
Can you provide a sample table show how is your model looks like, not just the expected output.Regards
Paul
