I need Help for my DAX. If the Cycle time is during The MCO how to calculate the days During MCO

[Anonymous]

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

[tamerj1 · Accepted 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]