summarize a table

[esmat]

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]

Hi @esmat 
Of course you need to include all other columns

Summary Table =
GROUPBY (
    ADDCOLUMNS ( 'Table', "Month Year", FORMAT ( 'Table'[Day], "MMM YYYY" ) ),
    [Month Year],
    "Value.USD", AVERAGEX ( CURRENTGROUP (), [Value.USD] ),
    "Value.JPY", AVERAGEX ( CURRENTGROUP (), [Value.JPY] ),
    "Value.BGN", AVERAGEX ( CURRENTGROUP (), [Value.BGN] )
)

[esmat]

Hi @tamerj1 

I obtained an error message as shown in yellow below

[tamerj1 · Accepted solution]

@esmat 
This is a calculated table not a measure

[esmat]

thank you very much 

it worked perfectly 

[johnt75]

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]

I got an error message as below