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 All,
I have 1 impediment to calculate the Days During MCO on my queries.
This is to calculate how many days are there by using start date MCO and End date MCO.
Below is the example of my queries.
For your reference below is the output that i wanted including the start date and the end date of the MCO
i include how i do calculate the Cycle time . How can i use queries or using measure to auto populate the Days During MCO for my Data.
Hope you all can help me.
Best regards
Thanks
Source Table
Item | Incurred | Resolved | Cycle Time | Days During MCO | Cycle Time Exclude MCO |
A | 8/29/2021 | 9/14/2021 | 17 | ||
B | 8/28/2021 | 9/14/2021 | 18 | ||
C | 8/26/2021 | 9/14/2021 | 20 | ||
D | 8/25/2021 | 10/10/2021 | 47 | ||
E | 8/25/2021 | 10/10/2021 | 47 | ||
F | 8/24/2021 | 10/10/2021 | 48 | ||
G | 8/23/2021 | 9/14/2021 | 23 | ||
H | 8/23/2021 | 11/30/2021 | 99 | ||
I | 8/20/2021 | 11/16/2021 | 89 | ||
J | 8/20/2021 | 9/14/2021 | 26 | ||
K | 8/19/2021 | 9/14/2021 | 27 | ||
L | 8/18/2021 | 9/14/2021 | 28 | ||
M | 8/18/2021 | 9/14/2021 | 28 | ||
N | 8/16/2021 | 9/14/2021 | 30 |
Solved! Go to Solution.
Hi @Anonymous
if you have the MCO end date fixed you can simply add new calculated columns
Days During MCO =
DATEDIFF ( DATE ( 2021, 9, 2 ), 'Source Table'[Incurred], DAY )
Cycle Time Exclude MCO =
'Source Table'[Cycle Time] - 'Source Table'[Days During MCO]
Hi @Anonymous
if you have the MCO end date fixed you can simply add new calculated columns
Days During MCO =
DATEDIFF ( DATE ( 2021, 9, 2 ), 'Source Table'[Incurred], DAY )
Cycle Time Exclude MCO =
'Source Table'[Cycle Time] - 'Source Table'[Days During MCO]
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 |
---|---|
47 | |
26 | |
19 | |
15 | |
10 |
User | Count |
---|---|
57 | |
50 | |
44 | |
21 | |
19 |