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

Hi buddy,

 

Try create a measure with this DAX:

Measure = AVERAGE(Table1[PAF])
 
 
The trick here is, everytime you use this measure just put the date on the month format from his hierarchy.
 
Any questions, ask ;)
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