- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Unable to configure count per month on a matrix table
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
Online Event
Register Here
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Microsoft Fabric Community Conference 2025
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
Subject | Author | Posted | |
---|---|---|---|
06-07-2024 03:58 PM | |||
07-12-2024 02:31 AM | |||
05-29-2024 06:04 AM | |||
03-05-2024 08:54 AM | |||
07-17-2024 03:52 PM |
User | Count |
---|---|
126 | |
79 | |
59 | |
58 | |
44 |
User | Count |
---|---|
181 | |
121 | |
82 | |
70 | |
54 |