How to calculate monthly uptime percentage from downtime minutes

[Anonymous]

Hello PowerBI community,

How do I calculate the uptime % per month with the data available below ? Can you please help me think through the DAX here? 

What I have 

S.No	Downtime Start Date	Downtime Minutes	Downtime End Date
1	1/1/2022	50400	2/5/2022
2	1/2/2022	46080	2/3/2022
3	1/3/2022	102240	3/15/2022
4	1/4/2022	28800	1/24/2022
5	1/5/2022	79200	3/1/2022
6	1/6/2022	80640	3/3/2022
7	1/7/2022	110880	3/25/2022
8	1/8/2022	50400	2/12/2022

What I want to calculate - 

S.No	Jan (uptime%)	Feb (Uptime%)	Mar (Uptime %)
1	0	82	100
2	3	89	100
3	6	0	52
4	10	100	100
5	13	0	97
6	16	0	90
7	19	0	19
8	23	57	100

Thanks in advance!

@amitchandak @Greg_Deckler  @Jihwan_Kim @lbendlin 

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure if I understood your question correctly, but please chech the below picture and the attached pbix file.

Uptime percentage measure: =
VAR _daysinamonth =
    COUNTROWS ( 'Calendar' )
VAR _downstreamdaysinamonth =
    COUNTROWS (
        FILTER (
            'Calendar',
            'Calendar'[Date] >= MAX ( Data[Downtime Start Date] )
                && 'Calendar'[Date] <= MAX ( Data[Downtime End Date] )
        )
    )
VAR _upstreamratio =
    DIVIDE ( _daysinamonth - _downstreamdaysinamonth, _daysinamonth )
RETURN
    IF ( HASONEVALUE ( Data[S.No] ), _upstreamratio )