Home Forums Power Pivot Running Total Days Hours Mins

This topic contains 0 replies, has 1 voice, and was last updated by  Bel 1 month, 1 week ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #11260

    Bel
    Participant
    • Started: 2
    • Replies: 0
    • Total: 2

    Hi
    Attached is a simplified version of the data model I am using.

    I have a Date table, which is my calendar table.  I have a time table, which contains a list of times.

    I have a Logins table, which contains a date and time stamp for each login.

    I have a couple of issues.  This first one is being able to create measures that can summarize my data appropriately using both the date and time together.  For instances, I can quite easily create a measure that is a running total of the number of logins per day.  I can also do the same at an hourly level.  However, when I include time[hours] in my pivot table, it is normally in conjunction with the date.  But when I do this, the running total keep resetting for each day, whereas I would like a running total that would continue to sum right until the end of the data set.

    Hope this makes sense.

    The 2nd issue I have is I am trying to work out how I can calculate the peak number of hourly logins per day, but having a few issues, because the Total number of logins measure is based on a countrows function.

    I’m trying to avoid an enormous date table which has all hours/mins for each day – is this unavoidable?

    If you could point in the right direction I would appreciate it very much.

    Best wishes
    Bel

    Attachments:
    You must be logged in to view attached files.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.