Forum Discussion
PBIUWO
Helper III
Helper IIICreating 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 in...
amitchandak
Super User
Super UserPBIUWO , 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#M428
vote for Hybrid Table
https://ideas.powerbi.com/ideas/idea/?ideaid=9bc32b23-1eb1-4e74-8b34-349887b37ebc
PBIUWOHelper III
Helper III
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,