Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
esmat
Regular Visitor

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 

esmat_0-1682330114725.png

 

 

1 ACCEPTED SOLUTION

@esmat 
This is a calculated table not a measure

View solution in original post

6 REPLIES 6
tamerj1
Super User
Super User

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

Hi @tamerj1 

I obtained an error message as shown in yellow below

 

esmat_1-1682333639878.png

 

@esmat 
This is a calculated table not a measure

thank you very much 

it worked perfectly 

johnt75
Super User
Super User

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

I got an error message as below

 

esmat_0-1682333408917.png

 

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.