Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Counting data per day if data rows are date/time format

Hi, I am just starting to use Power BI and currently, I am trying to generate a graph of user logins. My data sample looks like:   Server Date User ServerA 10/9/2019 12:24 User A Serve...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    Hi Anonymous 

     

    Could you please let me know if you'd like to get this one?

    1. I changed your date/time column as Date in power query:

    2. Add the measure :

    Measure = CALCULATE(DISTINCTCOUNT(Table1[User]),ALL(Table1),VALUES(Table1[Date]))

    3. Create the visual:

     

    Pbix attached.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Thanks for the tip! What I did was similar to this, creating a new column with just the date, no timing. I was finally able to achieve what I wanted.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorry nahid3152, as there will be hundreds of servers on the official data, I was hoping that I will just be able to create the visual without doing another pivot. I just showed the graph I created in Excel as an example of what I want the end result to be, just using the original data source. Is that possible in Power BI? Or do I need to create a measure to calculate the number of users who logged in per day? Thanks!

  • nahid3152's avatar
    nahid3152
    Icon for Helper II rankHelper II
    6 years ago
    Yes, I hope, You can do it in power bi using measure