Forum Discussion

manish_tripathi's avatar
manish_tripathi
Frequent Visitor
3 years ago
Solved

Calculate Monthly Active Users for Further Calculation

I am trying to calculate DAU/MAU ratio for my dataset. I am working to get cumulative distinct count of uids on montly basis. My dataset consists dates and UserIDs active on that date. I am able to c...
General Comment
Need Help
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    3 years ago

    manish_tripathi , Prefer to use a date table with month year column

    Try like

     

    calculate(distinctcount(Table[User ID]) , filter(allselected(Table) , eomonth(Table[Date],0) = eomonth(max(Table[Date]),0) ) )

     

     

    calculate(distinctcount(Table[User ID]) , filter(allselected(Date) , Date[Month Year] = Max( Date[Month Year] ) ) )

     

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

manish_tripathi , Prefer to use a date table with month year column

Try like

 

calculate(distinctcount(Table[User ID]) , filter(allselected(Table) , eomonth(Table[Date],0) = eomonth(max(Table[Date]),0) ) )

 

 

calculate(distinctcount(Table[User ID]) , filter(allselected(Date) , Date[Month Year] = Max( Date[Month Year] ) ) )

 

To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • manish_tripathi's avatar
    manish_tripathi
    Frequent Visitor
    3 years ago

    Thank you so much for quick response