Forum Discussion

tomislav_mi's avatar
tomislav_mi
Icon for Helper II rankHelper II
5 years ago

Dynamic Agregation - Cohort table

Hey guys, Hope you are keeping well! Can you please help me on this topic: Made a cohort table (as pivot table from the data set) that looks like this  Sum of MRR MonthsActive    ...
AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
5 years ago

Does adding ALL ( DimDate[Year-Month] ), assuming that's the appropriate column name, as another argument in CALCULATE help?

tomislav_mi's avatar
tomislav_mi
Icon for Helper II rankHelper II
5 years ago

AlexisOlson 

Thank you for your response!

Unfortunately, it doesn't.

  • AlexisOlson's avatar
    AlexisOlson
    Icon for Super User rankSuper User
    5 years ago

    Are your months coming from a date dimension table or the same table as [MMR]?

     

    If you don't have a separate dimension table, you might be running into an Auto-Exist issue.