Forum Discussion
ArchStanton
3 years agoPower Participant
Table Average Required
The following code gives me the Average for each month going back 3 Financial Years (FY exists in my Date Table)
Averages =
VAR _table = SUMMARIZE(Date2,Date2[FY],"Count",COUNT('Cases'[incidentid]))
RETURN
AVERAGEX(_table,[Count])
How Do I replace the total below with an overall monthly Average?
Thanks
ArchStanton , try a measure like
AVERAGEX(values(Date2[Month]),[Averages])
or
AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))
2 Replies
- amitchandakSuper User
ArchStanton , try a measure like
AVERAGEX(values(Date2[Month]),[Averages])
or
AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))
- ArchStantonPower ParticipantMany thanks, they both work perfectly!