Hey Guys,
So I have a simple table with a column of users and the day they accessed the system. In DAX I need to be able to determine whether the user is new or not on both a weekly and monthly basis. So somehow I need to be able to say - look at all the users and see which users first access point was within the last say 7 and 30 days to do weekly/monthly. Or 7/14/21 days to get the first 3 weeks or not sure how to figure out all the weeks but you get the point. Any thoughts suggestions on how I could do that in PowerBI desktop using DAX? Or helpful hints on where I could read up on how to do this would be appreciated as well.
So I have a simple table with a column of users and the day they accessed the system. In DAX I need to be able to determine whether the user is new or not on both a weekly and monthly basis. So somehow I need to be able to say - look at all the users and see which users first access point was within the last say 7 and 30 days to do weekly/monthly. Or 7/14/21 days to get the first 3 weeks or not sure how to figure out all the weeks but you get the point. Any thoughts suggestions on how I could do that in PowerBI desktop using DAX? Or helpful hints on where I could read up on how to do this would be appreciated as well.
