Forum Discussion

RichOB's avatar
RichOB
Icon for Post Partisan rankPost Partisan
1 year ago
Solved

Active numbers per quarter

Hi, I need to obatin the quarterly figures for active tenants per quarter. I have a date table with the quarter already.   In this scenario: I have properties where tenants have stayed short-term ...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi RichOB 

     

    I'm seeing a different number for Q4

    Count by Time Period = 
VAR StartDate =
    MIN ( Dates[Date] )
VAR EndDate =
    MAX ( Dates[Date] )
RETURN
    COUNTROWS (
        FILTER (
            Tenant,
            Tenant[Start_Date] <= EndDate
                && COALESCE ( Tenant[End_Date], TODAY() ) >= StartDate
            )
        )

    Please see the attached pbix. 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RichOB ,

 

I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.

 

Thank you.

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi RichOB ,

 

May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

 

Thank you.