Unable to configure count per month on a matrix table

[Anonymous]

Hello,

I am trying to configure a table with count per month and I am struggling...

I have different types of projects. Each of them have to go through different gates for the project to be completed. I want to have a table which shows how many gates have been passed on that specific month per project type.

Example:

Type of project	gate 1	gate 2	gate 3	gate 4
type 1	jan 2023	jan 2023	march 2023
type 1	jan 2023	feb 2023
type 2	jan 2023	march 2023	march 2023
type 3	feb 2023	feb 2023	march 2023	march 2023

What I want is this:

	jan 2023	feb 2023	mar 2023
gate 1	2	1	0
gate 2	1	2	1
gate 3	0	0	3
gate 4	0	0	1

is this doable?

Thank you!

[amitchandak]

@Anonymous , My advice would be to unpivot the gate columns in power query

Unpivot Data(Power Query): https://youtu.be/2HjkBtxSM0g

Power BI: Power Query Functions one must know
: https://www.youtube.com/watch?v=cN8AO3_vmlY&t=36407s
Power BI - Cheat Sheet: Power Query Functions one must know
https://amitchandak.medium.com/cheat-sheet-power-query-functions-one-must-know-a8531b6e321a