Forum Discussion

esmat's avatar
esmat
Regular Visitor
3 years ago
Solved

summarize a table

Hi All, I have a table with multi currency conversion factors, would like to summarize this table based on monthly average while maintaining all columns.   table is below     
  • tamerj1's avatar
    tamerj1
    3 years ago

    esmat 
    This is a calculated table not a measure

johnt75's avatar
johnt75
Super User
3 years ago

You could use something like

Monthly summary =
ADDCOLUMNS (
    SUMMARIZE ( 'Currency table', 'Date'[Year month] ),
    "Avg USD", CALCULATE ( AVERAGE ( 'Currency table'[Value.USD] ) ),
    "Avg JPY", CALCULATE ( AVERAGE ( 'Currency table'[Value.JPY] ) )
)
esmat's avatar
esmat
Regular Visitor
3 years ago

I got an error message as below