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
    10 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
      10 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

       

      • PANNEER's avatar
        PANNEER
        Frequent Visitor
        10 months ago

        Hi,
         Could you please provide me the dax formula for churn rate and occupancy rate  for agreements dashboard?