Hi,
I am new to Power BI and I need some help to recreate a retention analysis that I previously had in Tableau. We look at monthly active customers and are interested in how this differs by cohort (when the customer first started).
The output would look something like this for absolute values:
| | Month nr after start | | | | | |
| Starting month | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Jan-19 | 180 | 162 | 145 | 130 | 117 | 105 | 94 |
| Feb-19 | 120 | 108 | 97 | 87 | 78 | 70 | |
| Mar-19 | 130 | 117 | 105 | 94 | 84 | | |
| Apr-19 | 180 | 162 | 145 | 130 | | | |
| May-19 | 200 | 180 | 162 | | | | |
| Jun-19 | 160 | 144 | | | | | |
| Jul-19 | 100 | | | | | | |
And like this for % values (ideally in a heat map, so we can mark any % above e.g., 80% in shades of green, and below 40% in shades of red)
| | Month nr after start | | | | | |
| Starting month | 0 | 1 | 2 | 3 | 4 | 5 | 6 |
| Jan-19 | 100% | 90% | 81% | 72% | 65% | 58% | 52% |
| Feb-19 | 100% | 90% | 81% | 73% | 65% | 58% | |
| Mar-19 | 100% | 90% | 81% | 72% | 65% | | |
| Apr-19 | 100% | 90% | 81% | 72% | | | |
| May-19 | 100% | 90% | 81% | | | | |
| Jun-19 | 100% | 90% | | | | | |
| Jul-19 | 100% | | | | | | |
I have created a simplified version of the data structure (please note the data here does not match the tables above):
I have managed to do a summarized table of the first gym entry date by customer ID, however, I do not know how to now check whether a customer comes to the gym on each consecutive month.
All help would be very appreciated.
Thanks
Luisa
