Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Average By Columns with Filter and Dates

Hello, I have many columns and I would like to average using a filter and certain columns. So I want the "Value" field to be the average by Analyte, but only when AnalyteType = "Lab", and also only f...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
3 years ago
Avg = calculate(AVERAGE('Table'[Value]),'Table'[AnalyteType]="Lab",'Table'[DateEntered]>TODAY()-45)

Note that your sample result of "2" is not valid.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

This is the simplest formula. What if I need to add one more column to average by? So not a specific value, but I also want to average by color.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I can easily make these all in a table on the report, but then I don't know how to create a plot from a table in the report area. That might be the easiest thing to do. Is that possible?