Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone
So I got a dataset which looks like the following:
Raised date | raised week | responsibility | Closed date | closed week |
02/05/2022 | 2218 | A | 20/05/2022 | 2220 |
03/05/2022 | 2218 | B | 20/05/2022 | 2220 |
16/05/2022 | 2220 | A | 30/06/2022 | 2226 |
17/05/2022 | 2220 | C | 30/06/2022 | 2226 |
18/05/2022 | 2220 | B | ||
03/06/2022 | 2222 | B | 30/06/2022 | |
10/06/2022 | 2223 | B | 30/06/2022 | 2226 |
06/07/2022 | 2227 | C | 01/08/2022 | 2231 |
07/07/2022 | 2227 | C | 01/08/2022 | 2231 |
08/07/2022 | 2227 | A |
Now the goal is to check how many issues have been open like this:
(Legend for the colors is the responsible team)
Initially I was planning to do open issues - count of closed issues, but this is not working as I expected it would. I've created a caculated column
Amount Raised =
VAR UpdationDate = Sheet1[Raised date]
RETURN
COUNTROWS(
FILTER(Sheet1, Sheet1[Raised date] <= UpdationDate))
// FILTER(Sheet1, Sheet1[Raised date] <= UpdationDate))
Which works as expected, the second calculated column does not
I tried creating a similar for closed date, but the numbers never match. My end goal was to create a third calculated column subtracting those 2 from each other & putting it in a visual
Anyone that can support? Or has a better idea on how to proceed?
Thanks in advanced!
Solved! Go to Solution.
@Anonymous
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Indeed this looks exactly what I need, I didn't test it yet but it really looks good. Thanks a lot Greg!
@Anonymous
Take a look at these two Quick Measures as I think you want something like them.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Open-Tickets/m-p/409364
https://community.powerbi.com/t5/Quick-Measures-Gallery/Periodic-Billing/m-p/409365
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |