Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello all,
I have a table of tickets created in a helpdesk software for the last 5 years. I have a column of created date time and created time (in 24hr notation). I would like to present a graph that shows Hours on the x axis (0-24) and then the average count of tickets per hour. Any ideas would be lovely.
Solved! Go to Solution.
@apaulso9 , Create separate date and time columns and join them with date and time tables, have date and hour columns in respective tables
New column in your table
Date = datevalue([Created date])
Time = timevalue([Created date])
Create a measure like
sumx(values(Time[Hour]), calculate(sum(Table[Value])) )
Time Table
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
@apaulso9 , Create separate date and time columns and join them with date and time tables, have date and hour columns in respective tables
New column in your table
Date = datevalue([Created date])
Time = timevalue([Created date])
Create a measure like
sumx(values(Time[Hour]), calculate(sum(Table[Value])) )
Time Table
https://kohera.be/power-bi/how-to-create-a-time-table-in-power-bi-in-a-few-simple-steps/
https://radacad.com/script-for-creating-time-table-in-power-bi-with-hours-minutes-and-seconds-bucket...
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
85 | |
69 | |
67 | |
63 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |