Forum Discussion

miemer's avatar
miemer
Regular Visitor
7 years ago
Solved

Monthly average calculation

Hi everyone, i'm looking for help with a power-bi calculation: I have a table with 4 columns (date, time, Kiln, Paf) of which I want to calculate the monthly average of the PAF column. Here is an ...
  • Anonymous's avatar
    Anonymous
    7 years ago

    I couldn't do this way, but i have another solution that might help you.

     

    Create a table

    Table = SUMMARIZE(Table1;Table1[Date:])
    Create a column on that new table
    Column = CALCULATE(AVERAGE(Table1[Values:]);FILTER(Table1;Table1[Date:]='Table'[Date:]))
     
    This should get you this result.
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I couldn't do this way, but i have another solution that might help you.

 

Create a table

Table = SUMMARIZE(Table1;Table1[Date:])
Create a column on that new table
Column = CALCULATE(AVERAGE(Table1[Values:]);FILTER(Table1;Table1[Date:]='Table'[Date:]))
 
This should get you this result.
miemer's avatar
miemer
Regular Visitor
7 years ago

Thank you! exactly what I need