Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Trying to calculate Monthly Active users with the follwoing measure:
MAU = CALCULATE(
SUMX(VALUES('Usage '[Alias]),1),
ALL('Usage'[FullDate]),
DATESINPERIOD('Usage'[Date], LASTDATE('Usage'[Date]), -30, DAY)
)
This basically works fine and as expected. Using the measure in a trend chart, there is just one issue with the dates where we do not have distinct users - this leads to the situation that the DATESINPERIOD is not calculated correctly as there appears to be not start date. For this date only the users 30 days ago are being considered which is not what i want. See the screenshot attached.
Any thoughts how to fix that? Many thanks!
Solved! Go to Solution.
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,
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |