Calculating active figures

Hi RichOB ,

How do you consider a rent that finish before the end of the quarter is it active in the quarter or not?

In this calculation I have made the consideration that if end during the quarter is active and the values I get are 4, 6,8,6.

If I do not consider them to be active at the end of the quarter then the numbers are different:

The first one does not match your calculation

You need to have a calendar table has I refered with the fiscal quarter and year and then you can add one of two measures:

Leases in Period  with ended leases= 
COUNTROWS (
    FILTER (
        Rent,
        (
            Rent[Start_Date] <= MAX ( 'Calendar'[Date] )
                && Rent[End_Date] >= MIN ( 'Calendar'[Date] )
        )
            || (
                Rent[Start_Date] <= MAX ( 'Calendar'[Date] )
                    && Rent[End_Date] = BLANK ()
            )
    )
)

Leases in Period  without ended leases = 
COUNTROWS (
    FILTER (
        Rent,
        (
            Rent[Start_Date] <= MAX ( 'Calendar'[Date] )
                && Rent[End_Date] >= MAX ( 'Calendar'[Date] )
        )
            || (
                Rent[Start_Date] <= MAX ( 'Calendar'[Date] )
                    && Rent[End_Date] = BLANK ()
            )
    )
) 

Please see file attach.

Be aware that the calendar table is poorly build I just did some basic columns to make the example.