Forum Discussion
Aggregating by Date when Time Stamp Present - Please Help!
I am putting together a PBI report that tracks usage of a software application. Each time a user logs in, I receive a date and time stamp. I have added a column that associates the login with an in...
Couple different ways, easiest is to create a new column with a formula of:
Column = DATEVALUE([DateTime])
BTW, you don't need that column with all 1's and 0's in it, just use a COUNT aggregation.
Greg_Deckler
Community Champion
Community ChampionCouple different ways, easiest is to create a new column with a formula of:
Column = DATEVALUE([DateTime])
BTW, you don't need that column with all 1's and 0's in it, just use a COUNT aggregation.
Thanks - spot on. Appreciate the information.