Forum Discussion

MissMintox's avatar
MissMintox
Icon for Helper I rankHelper I
8 years ago

User retention calculation - Daily basis

I'm fairly new to Power bi and have tried and searched for this almost all the forums but couldn't find anything similar to mine. So.. I have a table like the following (Something similar)   ...
Need Help
v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi  MissMintox,

 

You may try with DATEDIFF Function (DAX) to calculate PreviousDayDistinctUsers.

 

PreviousDayDistinctUsers = CALCULATE(DISTINCTCOUNT('table'[User]), DATEDIFF('table'[Date],TODAY(),DAY))

You could modify the formula above according to your requirement.

 

If you need further help, could you share a dummy pbix file which can reproduce the scenario and you desired output, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)

 

Best regards,

Cherry