Forum Discussion
Calculate Retention Rate for two dates
Hi team,
I want to calculate the number of users that were active at date a and date b.
In this example the distinct number of users should be 2.
How can I calculate that with dax?
The following is my initial situation:
Date A -> 15.04.2020
| UserId |
| A |
| B |
| C |
Date B -> 08.04.2020
| UserId |
| Z |
| A |
| B |
| V |
4 Replies
- nandukrishnavs
Community Champion
power_roboter Can you provide a sample data set. Are you capturing dates in a different tables or the same table?
I have a column with UserIds (unique) that has a connection to a date table. So I can filter the userids for a specific day. Now I want to filter the userids for two days and calculate which users were active on both days.
Sample Table as image -> https://ibb.co/RvQRb0c
- nandukrishnavs
power_roboter - User will select always two days or multiple days?
