Forum Discussion

PANNEER's avatar
PANNEER
Frequent Visitor
10 months ago
Solved

occupancy & churn rate

Hi Friends, Currently I'm working on Agreements Dashboard in power bi. what is the churn rate and occupancy rate dax formula for agreements dashboard? can anyone provide me the solution for this?
Need Help
PANNEER's avatar
PANNEER
Frequent Visitor
10 months ago

Hi,
Thanks for the providing the solution, Clarify the below doubt.
Is the occupancy rate dax formula= Active agreements/agreements or Active agreements/Total units ?
and
In my agreements table i have start date and end date
Do i need to create a separate date table with start date. please advice?

    • v-menakakota's avatar
      v-menakakota
      Icon for Community Support rankCommunity Support
      9 months ago

      Hi PANNEER ,
      Thanks for reaching out to the Microsoft fabric community forum. 

       

      I would also take a moment to thank amitchandak   , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

      I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you .

       

       

      Best Regards, 
      Community Support Team  

      • v-menakakota's avatar
        v-menakakota
        Icon for Community Support rankCommunity Support
        9 months ago

        Hi PANNEER ,

        I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you 

         

        Best Regards, 
        Community Support Team

         

  • MattiaFratello's avatar
    MattiaFratello
    Icon for Super User rankSuper User
    10 months ago
    1. Active agreements/Total units
    2. It is recommended to create a date table if you want to use DAX time intelligence functions, such as calculating occupancy across time ranges or slicing by reporting periods. The date table should be continuous, cover all relevant dates, and have a single column with unique date values. Then relate the agreements' start and end dates to this date table, often using inactive relationships to allow custom measures for periods covered by each agreement. 

       

      • Create a date table using Power BI's CALENDAR or CALENDARAUTO DAX functions.

      • Mark your date table as a "Date Table" in Power BI for enabling advanced time-based calculations.

      • Set up relationships from your agreements' start/end dates to the date table (these can be inactive, used with DAX logic).

     

    If this helped please feel free to give kudos 👍