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.
miemer's avatar
miemer
Regular Visitor
7 years ago

Thanks, you've been very helpful.

However, I ask you something (maybe) more complex: can I create a column in the table with the monthly average value PAF, so that it is automatically filled in?

 

Here is the example table I would like to fill in automatically with the average column based on the date, line by line

 

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