Forum Discussion

rangeet1's avatar
rangeet1
Frequent Visitor
4 years ago
Solved

cohort

I am new in  this community. I am trying to make a cohort analysis. In which there two column dates in different tables , Enrollment date as first purchase date and sale dates as continious sales dat...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi rangeet1,

    Any update for these? if your table includes multiple date fields that are hard to map relationships, you can also try to unpivot the date fields to attribute and value.

    After these steps, you can simply link these unpivoted data values to a calendar and use a filter with attributes to choose filter date types.

    Unpivot columns (Power Query) (microsoft.com)

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi rangeet1,

Any update for these? if your table includes multiple date fields that are hard to map relationships, you can also try to unpivot the date fields to attribute and value.

After these steps, you can simply link these unpivoted data values to a calendar and use a filter with attributes to choose filter date types.

Unpivot columns (Power Query) (microsoft.com)

Regards,

Xiaoxin Sheng