Forum Discussion
Calculating weekly average for values
Hi, I'm trying to calculate a dynamic weekly average that is calculated as I change the filters on the table below. Current DAX I have is below, but it's not really working. AvgOutput = ...
steamexpert , Try a measure like
averageX(values(Project[End_Date__c]), CALCULATE(DISTINCTCOUNT(Project[Name])))
thanks for the quick response amitchandak , but something seems to be off with that calculation, see below. I also tried using End_Date__c (bins), but it didn't work either.