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
Count (MAX datetime group by user) by dates

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
-
Herbert Seidenberg 1,111 Reputation points
2021-06-27T01:49:23.91+00:00 0 additional answers
Sort by: Most helpful