Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Average a sum over specific date range

Hello,   I've got a measure which sums up three columns. If I'm looking at a single month then for example it brings back a value of 4000.    What I want to do is if the user selects a date range...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , Simple avg should do?

    Average(Table[Value])

    In case data need to aggregate before
    AverageX(Summarize(Table,Table[Month],"_1",sum(Table[Value])),[_1])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , Simple avg should do?

Average(Table[Value])

In case data need to aggregate before
AverageX(Summarize(Table,Table[Month],"_1",sum(Table[Value])),[_1])