The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello, I have a data model with the following columns and I am trying to find the monthly churn rate number. Can someone please advise what measures I have to write? (I also have a calendar table which is connected through all non-active relationships to both date columns -- this is key since there are multiple date columns I need to use in the measures??) The churn rate formula is: sum of deactivated users at the end of the month/sum of active users at the beginng of the month. I am very beginner, so having someone help me actually write the dax instead of point me to an article would be super helpful
User ID | User_Status | User_Activated_Date | User_Deactivated_Date |
1 | Activated | 12/12/19 | |
2 | Deactivated | 12/12/19 | 2/12/19 |
3 | Activated | 12/12/19 | |
4 | Deactivated | 12/12/19 | 3/12/19 |
5 | Activated | 12/12/19 |
Solved! Go to Solution.
Please refer to my blog very similar to what you need :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
In this blog churn =Terminated/ Current employees
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
Please refer to my blog very similar to what you need :https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
In this blog churn =Terminated/ Current employees
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges
Connect on Linkedin
@amitchandak this was very helpful for a lot of my work!! but I think my question still stands about the churn rate -- how do I make a measure with employees churned THIS period over active employees LAST PERIOD IF they each use DIFFERENT date columns? That is what I am confused about