Forum Discussion
count based on date
Hello, I am new to PowerBI and I am trying to create two measures, one for weekly active users, and one for monthly active users. I want the two measures to be calculated on a daily basis, so I ...
Hi tally ,
Please try the measure.
wau =
CALCULATE( COUNTROWS(growth),DATESINPERIOD(growth_sum[Date], MAX(growth[event date]), -7, DAY))
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hey,
Thank you so much for your time but it still not work.
The problem is that it still gives me all the dated and not the dates in this period.
Basically, I want a rolling WAU, so every day I will know the updated WAU for the last week..