Forum Discussion

tomislav_mi's avatar
tomislav_mi
Helper 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
Super 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
    Helper II
    5 years ago

    AlexisOlson 

    Thank you for your response!

    Unfortunately, it doesn't.

    • AlexisOlson's avatar
      AlexisOlson
      Super 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.