Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Create matrix table

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). OutputOutputInputInput

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 to set the relationship (if i need it).

Thank you so much!


Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors