Forum Discussion
Solved
Cohort Analysis
Hello, I would like to create a cohort analysis, showing the activity of users (grouped by signup month) over time. Therefore I could use the custom Heat-map visualization. The only thing I need ...
You could try:
Activity per Month cohort 1= CALCULATE(COUNTAX('activity'[login], 'activity'[cohort] = 1), AND((YEAR(Dates[Date]) = MAX(Dates[Year])) , (MONTH(Dates[Date]) = MAX(Dates[Month]))))
Might have an extra paren in there. Can't be sure unless I have some mock data to build a data model with and test.
You could try:
Activity per Month cohort 1= CALCULATE(COUNTAX('activity'[login], 'activity'[cohort] = 1), AND((YEAR(Dates[Date]) = MAX(Dates[Year])) , (MONTH(Dates[Date]) = MAX(Dates[Month]))))
Might have an extra paren in there. Can't be sure unless I have some mock data to build a data model with and test.
i am also having issues on how to start with cohort analysis on power bi.
Greg, can you assist?