Count (MAX datetime group by user) by dates

Zaytsev Vasily 201 Reputation points
2021-06-24T15:29:58.137+00:00

Hello, I have visual table with user activity in Power BI where I have two columns "User Name" and "Last activity datetime" (MAX datetime group by user) sorted by "Last activity datetime". I need linear diagramm on same page which count (MAX datetime group by user) by dates.
For example for this data:
"User Name":"Last activity datetime"
User1:24.06.2021 01:32
User2:24.06.2021 01:00
User3:23.06.2021 01:00
I need this linear diagramm:
24.06.2021:2
23.06.2021:1
and order column for first table as:
1:User1:24.06.2021 01:32
2:User2:24.06.2021 01:00
3:User3:23.06.2021 01:00
Kind regards, Vasily Zaytsev

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
36,987 questions
0 comments No comments
{count} votes

Accepted answer
  1. Herbert Seidenberg 1,191 Reputation points
    2021-06-27T01:49:23.91+00:00

    Excel 365 Pro Plus with Power Pivot and Power Query.
    Max DateTime group by user.
    With TimeLine and PivotChart.
    https://www.mediafire.com/file/28dcts5rk9nqxt5/06_26_21.xlsx/file
    https://www.mediafire.com/file/os44hjait1nazrs/06_26_21.pdf/file


0 additional answers

Sort by: Most helpful