Forum Discussion

sguenther's avatar
sguenther
Icon for Advocate II rankAdvocate II
10 years ago
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 ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    10 years ago

    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.

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
10 years ago

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.

 

GershwinMunich's avatar
GershwinMunich
Regular Visitor
8 years ago

i am also having issues on how to start with cohort analysis on power bi.

 

 

Greg, can you assist?