Forum Discussion

PANNEER's avatar
PANNEER
Frequent Visitor
9 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
9 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?

MattiaFratello's avatar
MattiaFratello
Icon for Super User rankSuper User
9 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 👍