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
Forum Discussion
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] )
)