Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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!
@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