Forum Discussion
Report On User Activity Throughout The Day
I'm looking for guidance on how you would display a report that tracks activities throughout the day.
My inputs are as follows:
Date time stamp
Activity
User
Would you create a date time table, then link to and chart the output, or would you go about it differently?
Hi Anonymous
My suggestion is to have a Date Table and link that to your main table then start creating your report.
The date table is a MUST for using time intelligence functions:
Create date tables in Power BI DesktopUse DAX time intelligence functions in Power BI Desktop models
Time intelligence functionsCreate a Date table with 3 clicks:
https://www.vahiddm.com/post/creating-calendar-table-with-3-stepsWhy we need Date Table:
https://www.youtube.com/watch?v=2f7dYB1l84ghttps://blog.enterprisedna.co/tips-in-creating-power-bi-date-tables/
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn | Twitter | Blog | YouTube
1 Reply
- VahidDM
Super User
Hi Anonymous
My suggestion is to have a Date Table and link that to your main table then start creating your report.
The date table is a MUST for using time intelligence functions:
Create date tables in Power BI DesktopUse DAX time intelligence functions in Power BI Desktop models
Time intelligence functionsCreate a Date table with 3 clicks:
https://www.vahiddm.com/post/creating-calendar-table-with-3-stepsWhy we need Date Table:
https://www.youtube.com/watch?v=2f7dYB1l84ghttps://blog.enterprisedna.co/tips-in-creating-power-bi-date-tables/
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn | Twitter | Blog | YouTube