Create matrix table

[jpendl22]

Dear Community, 

I am quite new to PowerBI, so any help is highly appreciated.

I have a table of records, where each record has an opening date and a closing date (and lots of other columns, but to understand the basic functionality i will just work with those three columns - record #, opening date, closing date).

I want to create a matrix, where the columns represent the Months (April to March), and the rows represent the sum of the records for the corresponding month (see example). OutputInput

I already have a Date Dimensions Table (not sure if i really need it).

Please, i need some starting help !Where to put which data and so on...how to set the relationship (if i need it).

Thank you so much!

[amitchandak]

@jpendl22 , you need to consider this hybrid

if you are looking for a Hybrid display with Matrix Column and measure
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

for date consider

Power BI: HR Analytics - Employees as on Date : https://youtu.be/e6Y-l_JtCq4
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...