Forum Discussion

kamstutz's avatar
kamstutz
New Member
4 years ago

DAX to Plot Sign-In Times & Aggregate Count for PowerBI Chart

I am trying to plot sign-in times in a PowerBI chart. I want the X-Axis to be the time (by half hour) of sign-ins and the Y-axis to be the aggregate count of sign-ins for the day. I need to create a column to aggregate the sign-ins based on time.

I’m trying to write a DAX that counts the number of sign-ins before the current sign-in, if it is on the same day. In the screen shot below, the 5:52:01 would have a column (Labor Count) with the number 1, the 5:56:12 would have 2 and so on until the next day.

 

DAX
powerbi
time

3 Replies

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    Hi,. kamstutz ;

    can you share  a simple data removing sensitive information, along with the results you want to output?

     


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • kamstutz's avatar
      kamstutz
      New Member
      4 years ago

      Yes, this is roughly what I am trying to accomplish. I have 'Date' & 'Time In' columns already, I need a calculation for column 'Onsite', which is the total amount of people on site that increases throughout the day as more people sign-in to our system.