Forum Discussion
samdep
Advocate II
Advocate IICohort Analysis
Hi Everyone! I am building a Cohort Analysis and am, I think, most of the way there -- but am struggling with my DAX Retention expression. I have a case open date (cases are grouped into coho...
amitchandak
Super User
Super Usersamdep , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Actually how can be case closed by 100% in month 1
DISTINCTCOUNT('Case'[CaseNumber]) is the open case in that month?
Other closed in that Month?
Are looking for opened vs open ratio?
refer if this can help https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
I have discussed similar stuff here