Forum Discussion

squarecat's avatar
squarecat
Icon for Helper I rankHelper I
1 year ago
Solved

Annual average from monthly average

Hello everyone,  I have a report built on Excel, but management wants it to be migrated to Power BI. In Excel I was using a dynamic table to obtain the sum of all the values per year and per month, ...
Need Help
  • johnt75's avatar
    johnt75
    1 year ago

    You can create a measure like

    Avg =
AVERAGEX (
    VALUES ( 'Date'[Year month] ),
    CALCULATE ( SUM ( 'Table'[Amount] ) )
)
squarecat's avatar
squarecat
Icon for Helper I rankHelper I
1 year ago

I also want to add that the number I obtained in the example by quarter refers to the Q1 (average of jan, feb and march)

Thanks in advance for any help!