Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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]
User | Count |
---|---|
20 | |
20 | |
14 | |
10 | |
8 |
User | Count |
---|---|
29 | |
28 | |
13 | |
12 | |
11 |