Forum Discussion
Frequency between dates
Hi Kim,
Many thanks for your time here.
This certainly seems like a good start. However, for this report the definiton of 'high frequency' is a user that has logged in 5 times or more at a specific location within a period of ANY 2 days.
I don't know when those 2 days might be, so using a slicer will not work. The measure I am trying to write must return 'users where 5 or more logins were made at an individual country within a 2 day period'.
I would like to see which country, user, date period.
So;
if user A logged in once a day for a week in London - i don't care.
If user A logged in 3 times on Jan 1st in Hawai and then 3 times on the 2nd in Paris - i don't care.
if user A logged in twice on Feb 1st in New York and 3 times on the 2nd in New York - i need to see that
if user A logged in twice on Mar 1st in Mexico and 3 times on the 2nd in Mexico - i need to that aswell
Many thanks again.
Terry
Hi,
Thank you for your message.
Sorry that I do not know how to create a sample that suits your situation, and please share your sample pbix file's link here. And then I can try to look into to it to come up with a more accurate solution.
Thanks.