Forum Discussion

schdef's avatar
schdef
Frequent Visitor
9 years ago
Solved

PBI Active Users calculation

Trying to calculate Monthly Active users with the follwoing measure:   MAU = CALCULATE(     SUMX(VALUES('Usage '[Alias]),1),     ALL('Usage'[FullDate]),     DATESINPERIOD('Usage'[Date], LASTDATE...
  • v-sihou-msft's avatar
    v-sihou-msft
    9 years ago

    schdef

     

    In this scenario, I don't understand why you have both [FullDate] and [Date] column in your table. I think your Usage table is a fact table which should include a Date column only. Then you can have another Full Date table and build relationship to Usage table. When can calculate the active users, you should use Full Date to limit the date range in DATESINPERIOD() function.

     

    Regards,

v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

schdef

 

In this scenario, I don't understand why you have both [FullDate] and [Date] column in your table. I think your Usage table is a fact table which should include a Date column only. Then you can have another Full Date table and build relationship to Usage table. When can calculate the active users, you should use Full Date to limit the date range in DATESINPERIOD() function.

 

Regards,