Occupancy ratio

Hi ChandraDXB 

You can create several measures as follow.

Q1 2022 = 
VAR _D1 =
    DATE ( 2022, 11, 1 )
VAR _D2 =
    DATE ( 2022, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), DAY ),
            DATEDIFF ( _D2, _D1, DAY )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, DAY ),
                DATEDIFF ( _D2, _D1, DAY )
            ),
            0
        )
    )

Q1 2023 = 
VAR _D1 =
    DATE ( 2023, 11, 1 )
VAR _D2 =
    DATE ( 2023, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), DAY ),
            DATEDIFF ( _D2, _D1, DAY )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, DAY ),
                DATEDIFF ( _D2, _D1, DAY )
            ),
            0
        )
    )

Q2 2022 = 
VAR _D1 =
    DATE ( 2022, 1, 1 )
VAR _D2 =
    DATE ( 2022, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), DAY ),
            DATEDIFF ( _D2, _D1, DAY )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, DAY ),
                DATEDIFF ( _D2, _D1, DAY )
            ),
            0
        )
    )

Q2 2023 = 
VAR _D1 =
    DATE ( 2023, 1, 1 )
VAR _D2 =
    DATE ( 2023, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), DAY ),
            DATEDIFF ( _D2, _D1, DAY )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, DAY ),
                DATEDIFF ( _D2, _D1, DAY )
            ),
            0
        )
    )

Q3 2022 = 
VAR _D1 = 
    DATE(2021, 12, 1)
VAR _D2 = 
    DATE(2022, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), MONTH ),
            DATEDIFF ( _D2, _D1, MONTH )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, MONTH ),
                DATEDIFF ( _D2, _D1, MONTH )
            ),
            0
        )
    )

Q3 2023 = 
VAR _D1 = 
    DATE(2022, 12, 1)
VAR _D2 = 
    DATE(2023, 11, 30)
RETURN
    IF (
        SELECTEDVALUE ( Table1[Start Date] ) >= _D1
            && SELECTEDVALUE ( Table1[Start Date] ) <= _D2,
        DIVIDE (
            DATEDIFF ( _D2, SELECTEDVALUE ( Table1[Start Date] ), MONTH ),
            DATEDIFF ( _D2, _D1, MONTH )
        ),
        IF (
            SELECTEDVALUE ( Table1[End Date] ) >= _D1
                && SELECTEDVALUE ( Table1[End Date] ) <= _D2,
            DIVIDE (
                DATEDIFF ( SELECTEDVALUE ( Table1[End Date] ), _D1, MONTH ),
                DATEDIFF ( _D2, _D1, MONTH )
            ),
            0
        )
    )

Then change the Format of each measure to Percentage.

Is this the result you expect?

If I've misunderstood you, please provide detailed sample data and the results you are hoping for. We can better understand the problem and help you. Show it as a screenshot or excel. Please remove any sensitive data in advance.

Best Regards,
Community Support Team _Yuliax
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.