Forum Discussion
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...
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.
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.
v-diye-msft
Community Support
Community SupportHi 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.
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.