Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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...
  • amitchandak's avatar
    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]))

  • Tahreem24's avatar
    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: