Forum Discussion

RichOB's avatar
RichOB
Post 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. 

v-tejrama's avatar
v-tejrama
Community Support
1 year ago

Hi RichOB,

 

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

 

If the response answered your query, kindly “Accept as Solution” and Give “Kudos” to help others in the community benefit from it as well.

 

Thank you.

Tejaswi.

 

v-tejrama's avatar
v-tejrama
Community Support
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.

 

  • v-tejrama's avatar
    v-tejrama
    Community Support
    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.