Forum Discussion
sbuster
Helper I
3 years agorecord with max value by day
I have a dataset below that has multiple records on a given day. What I would like to do is find the AssetID with the max number (count) of ExceptionID by day.... I was able to use groupby a...
Thennarasu_R
Responsive Resident
3 years agoHi sbuster
you Could try this one,
Measure=Maxx(values(transactions[Date]),Calculate(Count(transactions[ExceptionID]))
Thanks,
Thennarasu