Formula for volume of incidents by hour of day

[zurimae]

Formula to count how many calls by the Start of hour column

44 seconds ago

I need help figuring out how many "instances or calls" occured by the hour (start of hour). I have a column labeled Start Instant Date and i created a new column putting start time by "start of hour" .

I just want to know the volumn of calls or instance by day, by the hour (example, there were 30 times someone called a dr on 10/2/2024 at 12pm) The table is called Transfer Data and i would like to use a line/bar graph with date as X axis and hour as Y axis

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information. Do not include anything that is unrelated to the issue or question.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...