Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
I have a long column of dates and need to calculate each time a date occurs and then get the average of each time a date occurs over two weeks. Any help would be appreciated. Thanks!
@Anonymous ,
A measure like
averageX(values(Date[Date]), calculate(count(Date[Date])))
or with filter of two weeks
CALCULATE(averageX(values(Date[Date]), calculate(count(Date[Date]))) filter(Date, 'date'[Date] >= today() -14 || Date[Date] <=today()))
User | Count |
---|---|
63 | |
55 | |
46 | |
31 | |
31 |
User | Count |
---|---|
84 | |
74 | |
49 | |
48 | |
41 |