Forum Discussion
ArchStanton
Power Participant
Power ParticipantTable 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('Cas...
ArchStanton , try a measure like
AVERAGEX(values(Date2[Month]),[Averages])
or
AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))
amitchandak
Super User
Super UserArchStanton , try a measure like
AVERAGEX(values(Date2[Month]),[Averages])
or
AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))
ArchStantonPower Participant
Power ParticipantMany thanks, they both work perfectly!