Forum Discussion

tally's avatar
tally
Regular Visitor
4 years ago

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 ...
Need Help
parry2k's avatar
parry2k
Super User
4 years ago

tally as a best practice when you are working with time intelligence you should always add a calendar dimension in your model and then use that for all time intelligence DAX function. You can check my youtube playlist on time intelligence and also how to add a calendar table, and then recreate your measures using date from the calendar table and see if that fixes the issue.  https://youtube.com/playlist?list=PLiYSIjh4cEx2FkuGkngYruS0wm8MYFsoi

 

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

  • tally's avatar
    tally
    Regular Visitor
    4 years ago

    Thank you so much for replying!
    I already created this table and I tried doing the same measure with it but the result is the same...
    Do you have any other ideas why it won't work? or any other solutions for this measure?