March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
129 | |
90 | |
75 | |
58 | |
53 |
User | Count |
---|---|
200 | |
104 | |
101 | |
67 | |
55 |