Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
3 years ago
Solved

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('Cas...
Need Help
Show and Tell
  • amitchandak's avatar
    amitchandak
    3 years ago

    ArchStanton , try a measure like

    AVERAGEX(values(Date2[Month]),[Averages])

     

    or

     

    AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))

amitchandak's avatar
amitchandak
Super User
3 years ago

ArchStanton , try a measure like

AVERAGEX(values(Date2[Month]),[Averages])

 

or

 

AVERAGEX(values(Date2[Month]),calculate(COUNT('Cases'[incidentid])))

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    3 years ago
    Many thanks, they both work perfectly!