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

    Hi nahid3152,

     

    Thanks for sharing some thoughts on this and sharing your sample file. Unfortunately, I am unable to share online files due to org's security policy. However, I am attaching an Excel graph which is what I want to have in Power BI. 

     

    The file you shared is not what I was looking for. 

     

    My target graph

     

    Any thoughts on how to do this in Power BI?

      • 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!