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

Anonymous — Sat, 02 Apr 2022 10:20:13 GMT

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

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

tamerj1 — Sat, 02 Apr 2022 11:24:10 GMT

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]

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

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

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