Forum Discussion

TJK's avatar
TJK
Icon for Helper I rankHelper I
3 years ago

Average Monthly Count dynamically with Start Dates

I'm trying to create a Dax Calculation where it gives me the average number of dates entered monthly for the company or for specific employees selected in a slicer. If an employee is selected in the ...
average
averagex
COUNTA
nirali_arora's avatar
nirali_arora
Icon for Resolver II rankResolver II
3 years ago

You can add a month year column and use the following formula :

Divide( distinctcount('SDRs (Accounts)'[Start Date]), Calculate(distinctcount('SDRs (Accounts)'[Start  Month Year]),REMOVEFILTERS('SDRs (Accounts)'[Employee])))