Forum Discussion
Anonymous
5 years agoNot applicable
Count activity per Day
Hello everybody, I have this kind of table with two columns : userId and date Time of activity : userId activity date/time id1 14/01/2021 06:52 id1 04/01/2021 07:47 id1 04/01/20...
- 5 years ago
Anonymous , Create a date column from datetime and then try this column
countx(filter(Table, [userId] = earlier([userId]) && [date] = earlier([date])),[userId])
date columns
Date = [datetime].date
or
Date = date(year([datetime]),month([datetime]),day([datetime])) - 5 years ago
Anonymous ,
First create Calculated column to extract only Date part from Activity Datetime Column:
Date Column = FORMAT(Master[activity date/time],"DD/MMM/YYYY")Then Create measure to count based on newly created Date Column:Measure = CALCULATE(COUNT(Master[userId]),ALLEXCEPT(Master,Master[Date Column]))Screen shot attached:
Tahreem24
5 years agoSuper User
Anonymous ,
First create Calculated column to extract only Date part from Activity Datetime Column:
Date Column = FORMAT(Master[activity date/time],"DD/MMM/YYYY")
Then Create measure to count based on newly created Date Column:
Measure = CALCULATE(COUNT(Master[userId]),ALLEXCEPT(Master,Master[Date Column]))
Screen shot attached: