Creating a table with summarized values column with month/year as well?

[PBIUWO]

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

[Anonymous]

@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

[amitchandak]

@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/1...
https://community.powerbi.com/t5/Quick-Measures-Gallery/The-New-Hotness-Custom-Matrix-Hierarchy/m-p/...

vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc

[PBIUWO]

@amitchandak 

Right, 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,