The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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()))